Re: More time manipulation..

Thank you very much!!.. is there any where I can find more information
on Time Manipulation.. I looked under the idocs.. but they're really
lacking..

Travis

-----Original Message-----
From: Frank Bax [mailto:fbax(at)sympatico(dot)ca]
Sent: Monday, November 18, 2002 1:17 PM
To: Williams, Travis L, NPONS; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] More time manipulation..

select (Current_Date + interval '7 days')::date

At 02:07 PM 11/18/02, Williams, Travis L, NPONS wrote:

>If I do "select Current_Date".. I get something like:
>2002-11-25
>if I do "select Current_Date + interval '7 days'; I get:
>2002-11-25 00:00:00-06
>is there any way to get it to only return the parts I'm passing it (all
I
>want is the date).. I know I can do date_part and pull out the
individual
>parts and put it back together.. but it looks like I'm missing
something..
>
>Thanks,
>
>Travis
>
>---------------------------(end of
broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)