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
komal145
SSCrazy Eights
Points: 9915
More actions
July 27, 2016 at 3:50 pm
#1892391
I used Convert(varchar(19) , [Date] ,120 )
still i get the same in text file with datetimeoffset