New Datetime with timezone type

[synapsevampire]

I'm hoping that this new addition to the datetime resolves an age old problem for me, which is querying across multiple timezones.

If I have a datetime with timezone in it, can I:

select based on times for local times of 8AM, OR select on a UTC time (or some standard time) of 8AM by setting something?

The point is:

get all data for a specified date between 00:00 and 23:59 using the local time zone.

AND be able to

get all data for a specified date between 00:00 and 23:59 using a universal time?

By uing just one datetime field?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Abhivyakti]

Yes you can have only one date time field which will give you this data u need about diff time zones from one and hte same value in diff. timezones.

abhivyakti

 

[synapsevampire]

Thanks for the response.

Currently we store 2 datetimes, UTC and local. What sort of performance hit will I take for a 3 million row query if I move to using just one datetime with timezone to replace these 2, and convert the datetime on the fly?

Any other thoughts on this?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com