I need to convert a string date to an actual date

Question

I have a Date field in a table that is an int. The value looks like this: 20130618 I want to be able to convert that to an actual date like 06/18/2013 so I can do date calculations on it. How do I convert that field?

Change the table. Or what do you expect to do when you encounter a value like `20130299`? The design is broken. — Damien_The_Unbeliever, Jun 18 '13 at 17:29

t-clausen.dk · Accepted Answer · 2013-06-18T17:10:52.503

1

select convert(date, left(20130618, 8), 101)

or

select convert(date, cast(20130618 as char(8)), 101)

edited Jun 18 '13 at 17:10

answered Jun 18 '13 at 17:05

t-clausen.dk

43,517
12
59
92

Sorry, the field is actually an integer. – tsqln00b Jun 18 '13 at 17:07
Have altered my answer to operate on integers instead – t-clausen.dk Jun 18 '13 at 17:12

I need to convert a string date to an actual date

1 Answers1