I have mysql database and has columns teamname,description,timestamp.Here timestamp is set to current_timestamp. So when any record is inserted timestamp is automatically added.
Now I want to convert this timestamp datatime which is in the format "2013-04-18 10:00:00" to "2013-04-18T10:00:00Z" i.e. to UTC.
Is there any way to do this in a select query of mysql that will give me result in this format.