I need to convert a nvarchar
value to datetime
in T-SQL. The value is in ddmmyyyy
format, e.g. 23072009
I need to convert to datetime
in T-SQL.
I tried
select convert(datetime, '23072009', 103)
But it is throwing error.
"The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value."
Any idea
Thanks
See Question&Answers more detail:os