Home Forums Data Warehousing Integration Services truncation of datetime works fine in tsql but does not work when data loaded to txt file RE: truncation of datetime works fine in tsql but does not work when data loaded to txt file

  • July 28, 2016 at 9:11 am

    #1892501

    here is the ccolumn date output in text file :2016-07-05 02:38:52.1900000 +00:00

    The column from table is of type datetimeoffset

    truncation of timezone apprears in tsql but not when loaded to test file.

    Need the format 2016-07-05 02:38:52 in text file too.