If you actually typed 'febuary 2006' then type 'february 2006' and see what you get...
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Hageman Sent: Friday, February 18, 2005 1:30 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Guess I need a SET DATE refresher I set the date: R>set date 'mmm+ yyyy' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Here's my data: R>select schedule#,audit_date from audit schedule# audit_date ---------- -------------- 252 May 2005 203 November 2004 185 March 2005 253 February 2006 254 February 2006 255 February 2006 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I try a select with a WHERE: R>select schedule#,audit_date from audit where audit_date = 'febuary 2006' <WARNING> No rows exist or satisfy the specified clause. (2059) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I thought I should get the last 3 rows of data. help! (btw using 7.1.79.30214)
