I'm using QGIS 2.16.3 and attempting to convert a number of datetime fields that are appearing in the incorrect default GMT +0 timezone. I would like to add, for example, 10 hours to accurately reflect the time zone of data collection.
So far I've attempted using the field calculator:
"Date_Field" + ('10:00:00')
which just adds a string to the end (i.e. '2017-4-06 14:00:001')
I've also tried:
( "Date_Field") + to_time('10:00:00') ( "Date_Field") + to_datetime('10:00:00') to_datetime( "Date_Field") + to_datetime('10:00:00')
which gives me an error "Cannot convert '2017-04-06 14:00:00' to double", although I am able to convert the datetime field alone.
This seems like a simple, common operation for anyone working with different time zones. My only workaround is to create a CSV and edit the fields in a spreadsheet.