Re: Extracting time from timestamp

If the field is definately a timestamp field just do the following

SELECT TO_CHAR(stime,'HH24:MI') FROM bookings;

This will give you the desired answer

Darren

On Thu, 20 Mar 2003, Shridhar Daithankar wrote:

> Hi,
> 
> I know this is rather stupid but still,
> 
> I have a table which has a timestamp field in it and I need to get only time 
> part of it. i.e. HH:MI format.
> 
> So far I tried,
> 
> phd=# select to_timestamp( to_char(stime,'HH24:MI'),'HH24:MI') from bookings;
>       to_timestamp
> ------------------------
>  0001-01-01 04:30:00 BC
>  0001-01-01 04:30:00 BC
>  0001-01-01 04:30:00 BC
> (3 rows)
> 
> 
> I don't know where that BC crept in. It does not show up when I just select 
> stime from bookings;
> 
> I also tried
> 
> phd=# select timestamp to_char(stime,'HH24:MI'),'HH24:MI' from bookings;
> ERROR:  parser: parse error at or near "to_char" at character 18
> 
> To me that looks like casting a text returned by to_char to timestamp. This 
> casting should work if I infer from things like to_char(timestamp 
> 'now','HH12:MI:SS') mentioned in postgresql manual(Data type formatting 
> function, section 6.7).
> 
> Being very stupid, is there any more efficient way of doing this?
> 
> TIA..
> 
>  Shridhar
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
Darren Ferguson