RE: [GENERAL] SELECT Date

1998-10-12 Thread Andy Lewis
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 -

RE: [GENERAL] SELECT Date

1998-10-12 Thread Jackson, DeJuan
> 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 > -