Description
According to the Wikipedia entry on the ISO8601 spec (https://en.wikipedia.org/wiki/ISO_8601#Time_zone_designators), there are multiple valid ways to represent timezone offsets but the two I’m specifically interested in are:
+HHMM
+HH:MM
|
SELECT
|
DATE_FORMAT_STR('2016-05-15T00:00:23+00:00', '1111-11-11') as hours_minutes_delimited_tz, |
DATE_FORMAT_STR('2016-05-15T00:00:23+0000', '1111-11-11') as hours_minutes_tz, |
DATE_FORMAT_STR('2016-05-15T00:00:23+00', '1111-11-11') as hours_only_tz; |
|
{
|
"requestID": "307de121-24a5-4783-a1b1-f209495feb23", |
"signature": { |
"hours_minutes_delimited_tz": "string", |
"hours_minutes_tz": "string", |
"hours_only_tz": "string" |
},
|
"results": [ |
{
|
"hours_minutes_delimited_tz": "2016-05-15", |
"hours_minutes_tz": null, |
"hours_only_tz": null |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "1.382808ms", |
"executionTime": "1.366148ms", |
"resultCount": 1, |
"resultSize": 139 |
}
|
}
|
https://forums.couchbase.com/t/supporting-all-iso8601-timezone-formats/16104