Postgres Pro
Downloads
Home   >   mailing lists

Simplicity in time/date functions - Mailing list pgsql-general

From Ben-Nes Michael
Subject Simplicity in time/date functions
Date
Msg-id 03dc01c1948b$4e299ec0$aa0f5ac2@canaan.co.il
Whole thread Raw
Responses Re: Simplicity in time/date functions  (Darren Ferguson <darren@crystalballinc.com>)
Re: Simplicity in time/date functions  (Vince Vielhaber <vev@michvhf.com>)
Re: Simplicity in time/date functions  (Jason Earl <jason.earl@simplot.com>)
List pgsql-general
Tree view 
Hi All

I was amazed that:
select current_date() - 28 dont work at postgresql :(

I checked here and there and found that in postgresql i need to do something
like this:

select current_date::TIMESTAMP - '28 days'::INTERVAL as date

whow, is there a shorter way ?

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: Filtering a bunch of records to one after a selection has returned a bunch of them
Next
From: Darren Ferguson
Date:
Subject: Re: Simplicity in time/date functions