Gurus, I have a scenario where I need to figure out if the given data falls between the two dates.These two dates are two columns in which are datatype as Decimal(6,0).So my query according to requirement is something like this:
SELECT * from abc where columna='abc' AND '04/06/06'(date,format 'mm/dd/yy') Between col1 And col2.
Note: '04/06/06'(date,format 'mm/dd/yy') is the variable being passed. Col1 and col2: These are columns which are of decimal type(6,0) but they have dates as values.
Thanks for reading and if possible, please suggest me something.