pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: "TZ"/"tz" not supported
3+ messages / 2 participants
[nested] [flat]
* ERROR: "TZ"/"tz" not supported
@ 2005-06-28 10:20 Sergey Levchenko <sector119@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Sergey Levchenko @ 2005-06-28 10:20 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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 YYYY');
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* ERROR: "TZ"/"tz" not supported
@ 2005-06-28 11:39 Sergey Levchenko <sector119@gmail.com>
parent: Sergey Levchenko <sector119@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Sergey Levchenko @ 2005-06-28 11:39 UTC (permalink / raw)
To: pgsql-sql
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 YYYY');
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ERROR: "TZ"/"tz" not supported
@ 2005-06-28 14:31 Tom Lane <tgl@sss.pgh.pa.us>
parent: Sergey Levchenko <sector119@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-06-28 14:31 UTC (permalink / raw)
To: Sergey Levchenko <sector119@gmail.com>; +Cc: pgsql-general@postgresql.org
Sergey Levchenko <sector119@gmail.com> 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 to the table in datetime.c. (Someday we really need to
make that list configurable instead of hard-wired.)
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-06-28 14:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-28 10:20 ERROR: "TZ"/"tz" not supported Sergey Levchenko <sector119@gmail.com>
2005-06-28 11:39 ` Sergey Levchenko <sector119@gmail.com>
2005-06-28 14:31 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox