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 по дате отправления: