On Tue, Apr 3, 2012 at 7:11 PM, Bartosz Dmytrak <bdmytrak@xxxxxxxxx> wrote: > I think You can use epoch > there is an > example: http://www.postgresql.org/docs/9.1/static/functions-datetime.html > > > SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL '1 > second'; Yep, but when you do that a lot, your statement gets extremely long. I can create a function that'll hide the mess away, but what I'm hoping to do is simply cast: SELECT 982384720::timestamptz; ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
