See the documentation for Date/Time Types and Date/Time Functions and Operators:
http://www.postgresql.org/docs/7.4/static/datatype-datetime.html http://www.postgresql.org/docs/7.4/static/functions-datetime.html
if so, does that imply that i can translate these stored dates to any target time zone of my choosing when selecting the date from the db?
Yes -- see the aforementioned documentation.
well... the examples in the documentation work, but they only use static dates (hard-coded, i mean):
SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME ZONE 'PST';
but, when i try:
SELECT mydatecolumn FROM mytable AT TIME ZONE 'PST';
... i get a parse error.
same thing with:
SELECT TIMESTAMP WITH TIME ZONE mydatecolumn FROM mytable AT TIME ZONE 'PST';
any ideas?
thanks.
- philip
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
