DateTime and timezones question

[Guest]

Hey guys,

I need to compare two times that the user selects. The user selects the
hour, date, and timezone (which can be either NY, LN, or HK timezones).

How can I compare two dates of different timezones? For example:
Date1 = 11:30, 4/18/06, NY
Date2 = 16:30, 4/18/06, LN

These times should be considered equal (since of course LN time is +5 NY
time).

Any suggestions?

 

[Guest]

Hi Flack,

you should convert the dates to UTC time and than you can compare the both.

Regards