[RBG7-L] - Guess I need a SET DATE refresher

[James Hageman]

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)