Post reply

Bulk insert csv date 20-Jan-47 change to 2047-01-20 instead of 1947-01-20

  • December 16, 2016 at 2:55 am

    #324060

    hi,

    I have a csv file that I load in database via a bulk insert command, in my csv file I have a column date :

    for example :

    01-Jan-89 (in excel 01-01-1989), 20-Jan-47 (in excel 20-01-1947)... ,

    in my Database, the first date was ok : 1989-01-01 but the second date was : 2047-01-20 , instead of 1947-01-20 I don't understand this issue,

    any idea please ?

    thanks

  • December 16, 2016 at 4:13 am

    #1918351

    It's a configuration setting. See this article... Configure the two digit year cutoff

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • December 16, 2016 at 4:16 am

    #1918352

    Ok I will see, thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply