Re: Suggestions for 7.3 date handling

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <lockhart(at)fourpalms(dot)org>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Suggestions for 7.3 date handling
Date: 2002-02-07 05:27:27
Message-ID: GNELIHDDFBOCMGBFGEFOEEEOCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > How about adding these for 7.3? Can this be put in the TODO?
> >
> > EXTRACT(TIMESTAMP FROM epoch);
> > EXTRACT(DATE FROM epoch);
> > EXTRACT(DOW FROM epoch);
> > ...
>
> What do you want this to do exactly?

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')

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mkscott 2002-02-07 05:30:07 Re: Threaded PosgreSQL server
Previous Message Brian Bruns 2002-02-07 05:20:50 Re: DRDA, network protocol, and documentation