Re: 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)