Home Forums SQL Server 2005 SQL Server 2005 Integration Services concatenating date and time field RE: concatenating date and time field

  • August 2, 2013 at 10:57 am

    #1638279

    rs80 (8/2/2013)

    I ended up writing this code:

    (DT_DATE)((DT_STR,30,1252)TradeDate + " " + (DT_STR,30,1252)MessageTime)

    Nice, and thanks for the update.