Postgres Pro
Downloads
Home   >   mailing lists

Re: Suggestions for 7.3 date handling - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Suggestions for 7.3 date handling
Date
Msg-id Pine.LNX.4.30.0202071141130.683-100000@peter.localdomain
Whole thread Raw
In response to Re: Suggestions for 7.3 date handling  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
Christopher Kings-Lynne writes:

> OK, we have some legacy columns that use int4 as their type.  It would be
> nice to be able to do easy date handling with them.
>
> eg. EXTRACT(TIMESTAMP FROM EPOCH '1081237846')

timestamp 'epoch' + interval '1 second' * your_int

-- 
Peter Eisentraut   peter_e@gmx.net

pgsql-hackers by date:

Previous
From:
Date:
Subject: Re: Threaded PosgreSQL server
Next
From: Peter Eisentraut
Date:
Subject: Implementation details of schema permissions?