Details
Description
Difference in query results between Query workbench and Analytics. Date result is shown one day less on Analytics.
(On Query Workbench)
|
select millis_to_str(str_to_millis('2010-01-01')) as date |
[
|
{
|
"date": "2010-01-01T00:00:00-08:00" |
}
|
]
|
(On Analytics)
|
select millis_to_str(str_to_millis('2010-01-01')) as date; |
[
|
{
|
"date": "2009-12-31T16:00:00-08:00" |
}
|
]
|