Post reply

truncation of datetime works fine in tsql but does not work when data loaded to txt file

  • July 25, 2016 at 1:42 pm

    #315590

    I am trying to pull date format yyyy-mm-dd hh.mm.ss from '2016-07-05 02:38:52.1900000 -04:00'

    my sql:

    CONVERT(VARCHAR(19),datecolumn,120)

    this returns :2016-07-05 02:38:52.

    But when i load this column to my text file in ssis package from oledb to flatfile. it loads like this:

    2016-07-05 02:38:52.0000000 +00:00.

    Any reason why it behaves like this, can anyone tell me how to fix it?

  • July 25, 2016 at 2:21 pm

    #1891924

    You've been here long enough to know not to cross-post, so please don't. Answers here, please.

  • July 25, 2016 at 2:33 pm

    #1891926

    I wanted to delete this post in this section but could not. So, cross posted in correct section.

  • July 25, 2016 at 7:43 pm

    #1891947

    komal145 (7/25/2016)

    I wanted to delete this post in this section but could not. So, cross posted in correct section.

    You're right: you cannot delete your posts. Editing them, however, is trivial and involves clicking on the button marked 'Edit' and modifying the text you wrote.

Viewing 4 posts - 1 through 4 (of 4 total)

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