Sql Help

[vizagpower]

I have Date as 20131114 ,its a numeric datatype , so how do i convert it into datetime? 2013:11:14:00000

[tharun1222]

I have Date as 20131114 ,its a numeric datatype , so how do i convert it into datetime? 2014:11:14:00000

 

2013 kasta 2014 year kavala bhayya!

[vizagpower]

2013 kasta 2014 year kavala bhayya!

sorry my bad , let me edit it

[vizagpower]

2013 kasta 2014 year kavala bhayya!

no baiya 20131114 ani unnadi 2013:11:14:0000 ani kavali ,thanks for letting me know

[Papam_Pasivadu]

Babai to_date function tho avutadi emo!

[Osama Bin Gandhi]

I have Date as 20131114 ,its a numeric datatype , so how do i convert it into datetime? 2013:11:14:00000

SELECT convert(datetime, '20131114 ', 12)

 

idi try cheyyi

[SUbba LIngam]

select to_char(field, 'YYYY:MM:DD HH24:MI:SS') from record

 

select to_date(field, 'YYYY:MM:DD HH24:MI:SS') from record

[Osama Bin Gandhi]

Numeric annav kabatti idi try cheyy SELECT convert(datetime, convert(varchar,20131114) , 12)

I have Date as 20131114 ,its a numeric datatype , so how do i convert it into datetime? 2013:11:14:00000

 

 

SELECT convert(datetime, '20131114 ', 12)

 

idi try cheyyi

 

[vizagpower]

SELECT convert(datetime, '20131114 ', 12)

 

idi try cheyyi

thanks bro