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 25, 2016 at 10:30 pm

    #1891954

    Quick question, what is the output data type?

    😎

    This task is trivial and a simple conversion to SMALLDATETIME should do the trick

    DECLARE @dt DATETIME = GETDATE();

    SELECT

    @dt

    ,CONVERT(SMALLDATETIME,@DT,0)

    ;