|
Тема |
Re: local <--> GMT unix timestamp [re: gonzales] |
|
Автор |
salle (Един такъв) |
|
Публикувано | 05.11.01 17:29 |
|
|
select unix_timestamp(now()) as local_unixtimestamp, unix_timestamp(now() - interval 2 hour) as GMT_unixtimestamp, now() as local_time, now() - interval 2 hour as GMT_time;
i t.n.
Izpolzvai mysql DATETIME ili TIMESTAMP vmesto da pazish Unix timestamp (konvertiraneto e elementarno) i shte poluchish strahotnia nabor nam MySQL ot funkcii za smetki s dati i chasove i izobshto shte zabravish za saotvetnit e funkcii v PHP
Nai malkoto shte zabravish kak se konvertirat cahsove, dni, meseci kam secundi - MySQL si go mozhe
primer:
delete from log_table where ts > now() - interval 1 month;
Samo pomisli kak shte napravish neshto tolkova prosto v PHP :)
Linux is like a wigwam - No Windows, No Gates, Apache inside
|
| |
|
|
|