Re: datetime function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Bowlby <excalibur(at)hub(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: datetime function
Date: 2002-08-08 02:16:20
Message-ID: 28570.1028772980@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris Bowlby <excalibur(at)hub(dot)org> writes:
> Noticing an issue with the datetime funciton when being used with
> 'epoch', it is giving different results then before..

There is no "datetime function". What you have there is a
soon-to-be-obsolete alias for the timestamp datatype. What you
probably actually want is timestamptz (timestamp with timezone)
which is the current equivalent to the old datetime datatype...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-08-08 02:20:48 Re: CREATE FUNCTION
Previous Message Gregory Seidman 2002-08-08 00:28:42 Re: CREATE FUNCTION