Method: Convert GMT using offset
Function name: gmt_to_local
Parameter list: (CHAR input timestamp, CHAR GMT offset))
Return type: CHAR
What the method does: Converts a Greenwich Mean Time (GMT) timestamp and a specified offset to local time. Specify the offset in one of the following formats:
-
+hh:mm
-
-hh:mm
where:
-
- or +–the amount to subtract or add
-
hh–the hours to add or subtract from GMT
-
mm–the minutes to add or subtract from GMT
The local time is returned in the following format:
yyyy-mm-dd hh:mm:ss:ffffff
where:
-
yyyy–the year
-
mm–the month
-
dd–the date
-
hh–the hour, in a 24-hour clock (for example, 20 is 8:00 pm)
-
mm–minutes
-
ss–seconds
-
ffffff–fractions of a second
If the timestamp input is an empty string, an empty string is returned.
For example, if:
-
GMT timestamp is 2010-12-19 12:00:00:000000
-
Actual local time is 2010-12-19 07:00:00:000000
-
Specified offset is -03:00 hours
The returned local time is: 2010-12-19 04:00:00:000000