Skip to Content

excel date format in sql date bods

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded