conversion of a varchar data type to a datetime data type resulted in an out-of-range value. in sql query

Vote count:

0

i have a table with a column that store the date and time, i need to write a query to get only the date from that column,

Select cast(CONVERT(varchar, LoginTime, 101) as datetime) from AuditTrail 

but when i run the query i am getting this error,

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

can you help me please

asked 1 min ago

Noora

89

conversion of a varchar data type to a datetime data type resulted in an out-of-range value. in sql query