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