Calculating a datetime, converting 2008-05-15 12:00:00 to a time zone which is ten hours ahead using MySQL:

Required Date
2008-05-15 22:00:00