adding 3 hours to time stamp
Posted: Thu Jan 30, 2014 5:13 am
I have source data as Nvarchar
Source.
12/01/2013 15:13:17 -0800
12/09/2013 13:41:12 -0800
01/07/2014 07:09:40 -0800
I need to add 3 hours for only hours part.
12/01/2013 18:13:17
12/09/2013 16:41:12
01/07/2014 10:09:40
I tried to substing[1,19) then convert to string to timestamp then it is working but got stuck how to addd 3 hour to that time part any ideas?
Source.
12/01/2013 15:13:17 -0800
12/09/2013 13:41:12 -0800
01/07/2014 07:09:40 -0800
I need to add 3 hours for only hours part.
12/01/2013 18:13:17
12/09/2013 16:41:12
01/07/2014 10:09:40
I tried to substing[1,19) then convert to string to timestamp then it is working but got stuck how to addd 3 hour to that time part any ideas?