left() function in PostgreSQL

Question

I need to display only the hours of the time. The following script is my attempt to do the same.

Example:

select left(visittime,2) from records;

Here visittime contains:

10:00:00;

So I need to display only the 10 from it. I have tried by using above script but I am getting an error.

Error:

function left(time without time zone, integer) does not exist

That's a case for the manual rather than for SO: postgresql.org/docs/current/interactive/… and postgresql.org/docs/current/interactive/functions-datetime.html — Erwin Brandstetter
– Erwin Brandstetter, Commented Aug 11, 2014 at 14:05
@ErwinBrandstetter, Okay! Will take care next time. Thank you. — Sarfaraz Makandar
– Sarfaraz Makandar, Commented Aug 11, 2014 at 14:24

Clodoaldo Neto · Accepted Answer · 2014-08-11 13:59:59Z

3

select to_char(visittime, 'HH24') from records;

answered Aug 11, 2014 at 13:59

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Comments

Joseph B · Accepted Answer · 2014-08-11 14:05:41Z

3

Another alternative is to use the EXTRACT function, as below:

select extract(hour from visittime) from records;

Reference:

answered Aug 11, 2014 at 14:05

Joseph B

5,7291 gold badge17 silver badges19 bronze badges

You're welcome! The documentation on the website reference has a lot of information + examples for each function :-)