Answers for "Postgressql timestamp"

SQL
1

postgres get timestamp

SELECT CURRENT_TIMESTAMP;
Posted by: Guest on December-12-2020
0

unix timestamp postgres

select '2011-03-27 00:59:00.0+00'::timestamptz::timestamp::timestamptz
     , '2011-03-27 01:00:00.0+00'::timestamptz::timestamp::timestamptz;

/*
|timestamptz           |timestamptz           |
|:---------------------|:---------------------|
|2011-03-27 00:59:00+00|2011-03-27 02:00:00+01|
*/
Posted by: Guest on June-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language