Time zones question

View previous topic View next topic Go down

Time zones question

Post  hortoristic on Thu Apr 10, 2014 1:15 pm

If I'm trying to answer a question such as:

Show me all hospital beds that have movement (people leaving, people coming) between the hours of 1 AM and 3 AM for clinics sprinkled across the USA?

Will I be able to accomplish this with just tracking UTC time and local time datetime stamps in my dimensional model?

hortoristic

Posts : 7
Join date : 2012-05-29
Location : Seattle, WA

View user profile

Back to top Go down

Re: Time zones question

Post  ngalemmo on Thu Apr 10, 2014 1:36 pm

Yes. For this particular query you would use the local time.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum