Postgres Pro
Downloads
Home   >   mailing lists

More time manipulation.. - Mailing list pgsql-general

From Williams, Travis L, NPONS
Subject More time manipulation..
Date
Msg-id AB815D267EC31A4693CC24D234F8291602EE4DC8@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
Responses Re: More time manipulation..  (Gregory Seidman <gss+pg@cs.brown.edu>)
List pgsql-general
Tree view 
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
andpull out the individual parts and put it back together.. but it looks like I'm missing something.. 

Thanks,

Travis

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Authorise root as postgres
Next
From: Frank Bax
Date:
Subject: Re: More time manipulation..