excel date format in sql date bods

[former_member214617]

hi

I have excel sheet where column is of date datatype and date is 24/11/1958....

trying to upload excel sheet to sql server 2012 and column is showing null values... tried changing to to_char(datefield, 'yyyy.mm.dd') , to_date(to_char(datefield,'yyyy.mm.dd'),'yyyy.mm.dd'), substr as well

nothing is working..

[former_member521031]

Hi,

Since your column in excel is Datetime, it is would be sufficient to use only to_date function. use below function it will work.

to_date( datecolumn,'YYYY.MM.DD')

Thanks,

Rk