Answers for "postgresql get sys date"

postgresql get date now

If you want get the current date and time without timezone, you can cast it explicitly as follows:

SELECT NOW()::timestamp;
            now
----------------------------
 2017-03-17 18:37:29.229991
(1 row)
Code language: SQL (Structured Query Language) (sql)

Posted by: Guest on October-08-2021

postgresql get date now

SELECT NOW();
              now
-------------------------------
 2017-03-18 08:21:36.175627+07

Posted by: Guest on October-08-2021

Code answers related to "postgresql get sys date"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql get sys date"

Code answers related to "postgresql get sys date"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgresql get sys date"

Code answers related to "postgresql get sys date"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us