| From: | "Roderick A(dot) Anderson" <raanders(at)tincan(dot)org> |
|---|---|
| To: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
| Cc: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Simplicity in time/date functions |
| Date: | 2002-01-03 23:29:36 |
| Message-ID: | Pine.LNX.4.10.10201031525360.12068-100000@tincan.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3 Jan 2002, Jason Earl wrote:
>
> Try:
>
> processdata=> SELECT CURRENT_DATE - 28;
> ?column?
> ------------
> 2001-12-06
> (1 row)
Thank you. I have a totally trival view that I was making overly
complex. This fixes it.
Point to note is the use of 'interval' gives the same 'problem'
formating.
SELECT CURRENT_DATE - interval '28 days';
?column?
------------------------
2001-12-06 00:00:00-08
(1 row)
Cheers,
Rod
--
Let Accuracy Triumph Over Victory
Zetetic Institute
"David's Sling"
Marc Stiegler
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jochem van Dieten | 2002-01-03 23:47:00 | Re: PostgreSQL GUI |
| Previous Message | Johnson, Shaunn | 2002-01-03 23:02:55 | deriving a column from union |