How to select datetime from the PostgreSQL?

Question

I want to to select the time of a date from database. How can I do this using postgresql database?

Robban · Accepted Answer · 2009-09-15 11:48:00Z

1

You can use the date_part function, like this:

date_part('hour', timestamp '2001-02-16 20:38:40')

This would give you 20 for example.

answered Sep 15, 2009 at 11:48

Robban

6,8372 gold badges42 silver badges49 bronze badges

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

Comments

user80168 · Accepted Answer · 2009-09-15 12:10:25Z

0

Not sure what you exactly mean. Perhaps answer to your question is:

select now();

or maybe it's:

select now()::time;

answered Sep 15, 2009 at 12:10

user80168

Francisco R · Accepted Answer · 2011-04-13 12:38:42Z

0

Maybe:

select to_char (field, 'HH24:MI:SS') FROM table;

Example:

select to_char ('2011-04-13 11:22:33'::timestamp, 'HH24:MI:SS');

It gives you:

11:22:33

Replace

answered Apr 13, 2011 at 12:38

Francisco R

4,0471 gold badge24 silver badges37 bronze badges