Convert SQL Column DataType Int to Date Field
Posted on 2010-11-15
I have Column Field :- FillDate
DataType of this Column is Integer
Value is stored in the Table as Integer.
for which i already written a query to represent YYYY-MM-DD Format.
case when len(Rx.FillDate) = 7 then dateadd(d, (cast(RIGHT(Rx.FillDate,3) as int) -1), cast(LEFT(Rx.FillDate,4) as DATE))else null end as [FillDate]
Being Int DataType in the Table, I am not able to sort or write a Date based filteration.
If i need records between 10/01/2010 to 11/01/2010 .. some thing like date filteration , how should i do this ?