RE: [GENERAL] SELECT Date
От | Jackson, DeJuan |
---|---|
Тема | RE: [GENERAL] SELECT Date |
Дата | |
Msg-id | F10BB1FAF801D111829B0060971D839F46ABB5@cpsmail обсуждение исходный текст |
Список | 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. try: SELECT fagentname FROM feedback WHERE '@ 7 days'::timespan >= ftdate::datetime - now()::datetime; > 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 > >
В списке pgsql-general по дате отправления: