CODEWITHSUNDEEP
sql-server
Arun Rana
Arun Rana

Reputation: 8584

could not convert varchar to datetime in SQL server

In my database i got problem when converting varchar to datetime due to different format of datetime as per below.

Conversion failed when converting date and/or time from character string.

I have 2 select clause as per below

Select Getutcdate()
Select top 1 localmachinetime from perfmon

both return following format respectively

2012-05-28 06:54:45.753>

28-05-2012 03:03:07

and when i try to convert it to datetime using CAST then it gives me error in second case as per below.

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

Upvotes: 0

Views: 1094

Answers (1)

Mikael Eriksson
Mikael Eriksson

Reputation: 139010

You can use convert with a Date/Time style.

convert(datetime, '28-05-2012 03:03:07', 105)

Upvotes: 2

Related Questions