More time manipulation..

From: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: More time manipulation..
Date: 2002-11-18 19:07:42
Message-ID: AB815D267EC31A4693CC24D234F8291602EE4DC8@ACCLUST02EVS1.ugd.att.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Bax 2002-11-18 19:16:50 Re: More time manipulation..
Previous Message Robert Treat 2002-11-18 18:05:39 Re: Press Release -- Just Waiting for Tom