4 Replies Latest reply: Jan 17, 2017 9:08 AM by Tim Kendrick RSS

    SQL Data change

    Kevin Schütz

      Hello together,

       

      I load from my SQL Server to rows "Datum" and "Uhrzeit". Like this:

       

      DatumUhrzeit
      2016-04-28 00:00:00.0001899-12-30 04:00:00.000
      2016-04-28 00:00:00.0001899-12-30 05:00:00.000
      2016-04-28 00:00:00.0001899-12-30 06:00:00.000
      2016-04-28 00:00:00.0001899-12-30 06:19:05.000
      2016-04-28 00:00:00.0001899-12-30 07:00:00.000
      2016-04-28 00:00:00.0001899-12-30 08:00:00.000
      2016-04-28 00:00:00.0001899-12-30 09:00:00.000
      2016-04-28 00:00:00.0001899-12-30 10:00:00.000

       

      From the row "Datum" I just need the 2016-04-28

      and from the row "Uhrzeit" I need the 04:00:00.000 and 05:00:00.000 and so on

       

      Like this:

       

      DatumUhrzeit
      2016-04-28 04:00:00.000
      2016-04-28 05:00:00.000
      2016-04-28 06:00:00.000
      2016-04-28 06:19:05.000
      2016-04-28 07:00:00.000
      2016-04-28 08:00:00.000
      2016-04-28 09:00:00.000
      2016-04-28 10:00:00.000

       

      How I can realized this?