filtering data on date while fetching from SAP

[sudeep_d]

Hi,

zicrm:

load

/bic/submiton,

zcaldate,

z_z4

sql select  /bic/submiton,zcaldate,z_z4 from /bic/zicrm;

In the above mentioned eg, i want to filter data on datefield i.e(/bic/submiton) for last two days including today,

where /bic/submiton has data in text format e.g: 01-aug-2012,

now how do i convert this text into date format and compare with todays date in sql and fetch only last 2 days data

in short ,what should be my where statement to get last two days data???

any help would be appreciated

Thanks

Sudeep