postgres timestamp extract date from bigint datatype

Question

I inserted date (timestamp unix format) into postgres table using php. here below is the field structure.

last_dwnld
(bigint)
-----------
1408788007
1408190322

Field data type is bigint and its contain timestamp. field name is last_dwnld.

please let me know how to extract date using postgres query. last_dwnld::DATE is not helping here.

iainn · Accepted Answer · 2016-04-21 10:00:56Z

1

Postgres's internal to_timestamp function handles this (since 8.1)

Select to_timestamp(1408788007); -- 2014-08-23 10:00:07+00

answered Apr 21, 2016 at 10:00

iainn

17.4k9 gold badges38 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1