Datatype conversion
Posted: Mon Oct 13, 2008 1:03 am
Hi,
I have problem in converting char string to datetime datatype.The macro Datetimestamp is being passed as a user status to the next job where i am deleting the record from SQL table if the Extrctdte(One of the column in the table) is equal to Datetimestamp.Here i am getting an error as "Syntax error converting datetime from character string". Please help me to convert the string into datetime format.
I have problem in converting char string to datetime datatype.The macro Datetimestamp is being passed as a user status to the next job where i am deleting the record from SQL table if the Extrctdte(One of the column in the table) is equal to Datetimestamp.Here i am getting an error as "Syntax error converting datetime from character string". Please help me to convert the string into datetime format.