Re: More time manipulation.. - Mailing list pgsql-general

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@postgresql.org)