From: | Andy Lewis <alewis(at)mpsi(dot)net> |
---|---|
To: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] SELECT Date |
Date: | 1998-10-12 15:08:56 |
Message-ID: | Pine.LNX.3.96.981012100648.21361B-100000@shell.mpsi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I tried this but, got the following:
---------------------------------------
mytest=> select fagentname from feedback where ftdate between now()::date and
mytest-> (now()::datetime - '@ 7 days'::timespan)::date;
ERROR: function date(timestamp) does not exist
---------------------------------------
I have this column identified as type date and not timestamp.
Any suggestions?
On Thu, 8 Oct 1998, Jackson, DeJuan wrote:
>> >I have a table with somedate defined as date.
>> >
>> >I want to select all rows that are from todays date back to 7 days
>> >ago. Or in this case 10-1-1998.
>>
>> Use the function age() somewhat like this:
>>
>> select * from sometable
>> where date_part( 'epoch' , age( 'now', somedate ) ) > 604800
>>
>> The 'epoch' date part is the total number of seconds between the two
>> dates.
>> For other variations, see:
>>
>> http://www/postgresql.org/docs/user/functions1574.htm
>>
>Why don't you just use between:
>select * from sometable
>where somedate between now()::date and (now()::datetime - '@ 7
>days'::timespan)::date;
> -DEJ
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1998-10-12 16:49:59 | RE: [GENERAL] SELECT Date |
Previous Message | Sferacarta Software | 1998-10-12 13:42:06 | Re: |