-
1. Re: Tableau Server database timestamp
Russell Christopher Jul 19, 2012 6:50 AM (in response to John Cantu)Hey John -
We store timestamps in UTC in the base tables. Our reports (like the admin reports on the "Maintenance" page) figure out the offsets automatically. However, if you go directly to the base views/tables yourself, it's up to you to add / subtract your UTC offset based on what timezone you're in.
Good luck!
-
2. Re: Tableau Server database timestamp
John Cantu Jul 19, 2012 7:02 AM (in response to Russell Christopher)Oohhhhhhhhhh!! Okay! Understood! Thanks for the quicky reply.
-
3. Re: Tableau Server database timestamp
deepak.ujania Feb 25, 2013 9:09 AM (in response to John Cantu)Need some clarification on the statement:
"Our reports (like the admin reports on the "Maintenance" page) figure out the offsets automatically"
So Is there a Calculation or Tableau Server takes care of the Offset ( including Day light savings) based on the Server location?
If Tableau Server takes care of it why do we need t o "add / subtract UTC offset based on what timezone I am in."
thanks!
Deepak Ujania
-
4. Re: Tableau Server database timestamp
Russell Christopher Feb 25, 2013 9:17 AM (in response to deepak.ujania)The Tableau Server admin reports which you consume from the Tableau Portal does the time offset work.
This thread is talking about consuming data directly from the Tableau database tables, before the date/time values are massaged by our admin reports.
Therefore, you need to massage.