Re: Unixtime function?...
| От | Gyozo Papp |
|---|---|
| Тема | Re: Unixtime function?... |
| Дата | |
| Msg-id | 01be01c0d3c9$f7241c40$2248c5d5@jaguar обсуждение исходный текст |
| Ответ на | Unixtime function?... (Richard Whittaker <richard@connections.yk.ca>) |
| Список | pgsql-php |
Greetings:
In MySQL there is a function to convert an arbitrary date/time combination
to a Unix timestamp, which makes it really easy to perform calculations in
PHP, since the result was always an integer... Is there a similar function
out there for PostgresSQL or PHP?...
yes,there is a function called :
- date_part(text, timestamp),
and another :
- date_trunc(text, timestamp),
(from the manual of postgres v7.0.2)
For the date_part and date_trunc functions, arguments can be `year', `month', `day', `hour', `minute', and `second', as
wellas the more specialized quantities `decade', `century', `millennium', `millisecond', and `microsecond'. date_part
allows`dow' to return day of week, 'week' to return the ISO-defined week of year,
and **`epoch'** to return seconds since 1970 (for timestamp) or 'epoch' to return total elapsed seconds (for interval).
(from the manual of PHP )
int mktime (int hour, int minute, int second, int month, int day, int year [, int is_dst])
Returns the Unix timestamp corresponding to the arguments given. This timestamp is a long integer containing the number
ofseconds between the **Unix Epoch ** (January 1 1970) and the time specified.
so what you need is, for example:
SELECT date_part('epoch', current_timestamp);
В списке pgsql-php по дате отправления: