Re: php, time and postgresql

Rasmus Resen Amossen <spunk(at)rhk(dot)dk> writes:
> I want to save some time information in postgresql with php. What is the
> datatype in postgresql coresponding to the mktime()-unixtime function in
> php (creates a time in the format "979333398" eg.)?

You can coerce an integer representing a Unix timestamp to abstime,
and thence to any other datetime datatype you might want to use.

play=> select now()::abstime::integer;
?column?
-----------
979337141
(1 row)

play=> select 979337141::integer::abstime;
?column?
------------------------
2001-01-12 17:05:41-05
(1 row)

The "official" way to get from a datetime type to a Unix timestamp is
date_part('epoch', timevalue):

play=> select date_part('epoch', now());
date_part
-----------
979337212
(1 row)

but I don't know of any easy way to go in the other direction except by
casting to abstime.

regards, tom lane