Problem in converting the hour

Databases
1

Hi, I need your help please,I have table (tblarrival) and it has column called(arrival) that stored “datetime”

this is the value of my column arrival

2014-04-14 02:20:16
2014-04-14 02:21:23
2014-04-14 02:21:24
2014-04-14 02:25:22
2014-04-14 02:25:22
2014-04-14 02:25:22

How do i convert the hour 02 to 14 ?..to be like this

2014-04-14 14:20:16
2014-04-14 14:21:23
2014-04-14 14:21:24
2014-04-14 14:25:22
2014-04-14 14:25:22
2014-04-14 14:25:22

Thank you in advance.

2

add 12 hour


UPDATE tblarrival
   SET arrival = arrival + INTERVAL 12 HOUR
3

Hi r937,

It’s working …Thank you so much :slight_smile: