chinnaseenu
IS-IT--Management
Hai,
I've SQL Server Column 'DueDate' that is a string data type but it stores a date value
as 'yyyymmdd'(eg:20050816) i want to convert it into integer ,when i use SQLServer function
cast_integer([DueDate]) i'm getting the error that the function does not exist.
please any kind of help would be great i'm stuck with that for couple of days.
THANX alot
I've SQL Server Column 'DueDate' that is a string data type but it stores a date value
as 'yyyymmdd'(eg:20050816) i want to convert it into integer ,when i use SQLServer function
cast_integer([DueDate]) i'm getting the error that the function does not exist.
please any kind of help would be great i'm stuck with that for couple of days.
THANX alot