CODEWITHSUNDEEP
sqlsql-server
Osama Ashraf
Osama Ashraf

Reputation: 25

Convert Date to formatted date

I have a column for dates and the values are like this 1181202 and i want to convert it to normal date format "02-12-2018" so i can compare it with another date however when i am trying the following it returning wrong year and date 

SELECT CONVERT(Datetime, Text_UPD_DATE,106) -- i have tried all numbers 
 From Notes

it's returning 5134-01-09 00:00:00.000

Can you please advise on the correct command

Upvotes: 0

Views: 73

Answers (1)

Thom A
Thom A

Reputation: 95588

At a total guess, based on your one example:

CONVERT(date,'20'+STUFF(Text_UPD_DATE,1,1,''),112)

Upvotes: 1

Related Questions