Skip to Content
0

excel date format in sql date bods

Nov 17, 2017 at 08:24 AM

35

avatar image

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..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Nov 17, 2017 at 10:52 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded