DateTime convert in SQL

Question

I have DateTime saved as Integer in row of table in format 20111111. I want to display it by select to : 2011-11-11.

Please give me some as simpliest solution.

The Datetime is in table and looks like:

Table_name
20111212
20111113
20111212

and i want to display it like

Table_name
2011-12-12
2011-11-13
2011-12-12

MS SQL Server 2012

Check if this helps http://stackoverflow.com/questions/3855867/convert-int-to-datetime-sql — MusicLovingIndianGirl, Nov 22 '13 at 12:15
http://stackoverflow.com/questions/7830002/how-to-convert-int-to-date-in-sql-server-2008 — Damodaran, Nov 22 '13 at 12:15

score 1 · Answer 1 · edited Nov 22 '13 at 12:51

1

Please try

declare @a int
    set @a ='20111212'

    select stuff(stuff(@a,len(@a)-3,0,'-'),len(@a)-0,0,'-')

    --> 2011-12-12

edited Nov 22 '13 at 12:51

Nunser

answered Nov 22 '13 at 12:31

vhadalgi

Tim Schmelter · Answer 2 · 2013-11-22T12:31:30.947

0

You can cast it to varchar, then to datetime, then use CONVERT with the proper style:

SELECT CONVERT(VARCHAR(10),CAST(CAST(20111111 AS VARCHAR(10))AS DATETIME), 120)

edited Nov 22 '13 at 12:31

answered Nov 22 '13 at 12:20

Tim Schmelter

score 0 · Answer 3 · answered Nov 22 '13 at 13:23

0

Try this

CONVERT(varchar, Year(column)) +'_' + CONVERT(varchar, Month(column)) +'_'+ 
  CONVERT(varchar, Date(column))

answered Nov 22 '13 at 13:23

ranjeet

score 0 · Accepted Answer · answered Nov 23 '13 at 09:44

0

Problem solved by:

CONVERT(date, CAST(dbo.database_name.table_name AS CHAR(12)), 112) AS table_name

answered Nov 23 '13 at 09:44

Michal

4 Answers4