Does anyone have a 'table of timezones' that could be used to "localize"
as part of a query?
For instance, something like:
SELECT date
FROM table
WHERE ( time || ' ' || ( SELECT timezone
FROM zones
WHERE id = table.timezone )) = '2004-12-12';
Something like this, but that works:
# select ( now() || ' ' || 'PST8PDT' )::timestamp;
ERROR: invalid input syntax for type timestamp: "2005-06-26 00:23:29.789703-03
PST8PDT"
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
