[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Hopefully simple date conversion question
From:       "Jason C. Pion" <jpion () home ! com>
Date:       2000-07-29 17:49:47
[Download RAW message or body]

On Fri, 28 Jul 2000, Tom Lane wrote:

>   * convert the value to Unix timestamp notation (subtract off enough
>     days to make 0 correspond to 1/1/1970, then multiply by 24*60*60).
>   * coerce the resulting integer to abstime and then to whatever
>     datatype you want to use (timestamp or date, likely).

This worked perfectly.  Thanks very much for the help.
 
> This will not work if you have any dates before about 1900, however,
> since the Unix timestamp value would underflow.

No problem there.  Thankfully, none of the dates go that far back.
 
> 			regards, tom lane

Thanks again for all the work on PostgreSQL.

Jason

[prev in list] [next in list] [prev in thread] [next in thread]