Re: datetime function - Mailing list pgsql-general

From Tom Lane
Subject Re: datetime function
Date
Msg-id 28570.1028772980@sss.pgh.pa.us
Whole thread Raw
In response to datetime function  (Chris Bowlby <excalibur@hub.org>)
List pgsql-general
Chris Bowlby <excalibur@hub.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

pgsql-general by date:

Previous
From: Gregory Seidman
Date:
Subject: Re: CREATE FUNCTION
Next
From: Tom Lane
Date:
Subject: Re: CREATE FUNCTION