What is the equivalent of the SQLite datetime function in PostgreSQL?

Question

The question is pretty self-explanatory. I'm looking for a PostgreSQL equivalent to the SQLite datetime function.

Vinko Vrsalovic · Accepted Answer · 2008-09-24 12:49:10Z

6

postgres=# select to_char(now(),'YYYY-mm-dd HH:MM:ss');
       to_char
---------------------
 2008-09-24 02:09:20
(1 row)

postgres=# select to_char(now(),'YYYY-mm-dd HH24:MM:ss');
       to_char
---------------------
 2008-09-24 14:09:20
(1 row)

answered Sep 24, 2008 at 12:49

Vinko Vrsalovic

342k55 gold badges341 silver badges374 bronze badges

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

Comments

DeeCee · Accepted Answer · 2008-09-24 12:53:32Z

4

I think this is what your're searching for:

timestamp [ (p) ] [ without time zone ] or timestamp [ (p) ] with time zone

otherwise have a look @ http://www.postgresql.org/docs/8.1/interactive/datatype-datetime.html

answered Sep 24, 2008 at 12:53

DeeCee

4002 silver badges6 bronze badges

Comments

John Goering · Accepted Answer · 2008-09-24 13:15:41Z

2

OK, thanks for the answers, they helped point me in the right direction. What I actually was looking for was to_timestamp.

answered Sep 24, 2008 at 13:15

John Goering

39.2k59 gold badges164 silver badges247 bronze badges

Collectives™ on Stack Overflow

What is the equivalent of the SQLite datetime function in PostgreSQL?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related