Extracting time from timestamp
| От | Shridhar Daithankar | 
|---|---|
| Тема | Extracting time from timestamp | 
| Дата | |
| Msg-id | 200303202136.53992.shridhar_daithankar@persistent.co.in обсуждение исходный текст | 
| Ответы | Re: Extracting time from timestamp Re: Extracting time from timestamp | 
| Список | pgsql-general | 
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
		
	В списке pgsql-general по дате отправления: