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 8:46 am

    #1638209

    I ended up writing this code:

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