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<shridhar_daithankar(at)persistent(dot)co(dot)in> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Darren Ferguson