When I execute query, I've got error message.
test= SELECT to_timestamp('00:00:05.601 SAMST Tue Jun 28 2005',
'HH24:MI:SS.MS TZ Dy Mon DD ');
ERROR: TZ/tz not supported
How can I convert '00:00:05.601 SAMST Tue Jun 28 2005' (varchar type)
to timestamp with time zone?
Sergey Levchenko [EMAIL PROTECTED] writes:
How can I convert '00:00:05.601 SAMST Tue Jun 28 2005' (varchar type)
to timestamp with time zone?
Just casting it would work, except that SAMST is not one of the time
zone abbreviations known to Postgres. If you're desperate you could
add an entry