SQL datetime and time zone

Hi,

Sandeepmhatre posted this question in interview Experience Section but it should be in this forums, so i just posted his question here.


I had asked one question related datetime and timezone in a interview

Let me consider one example to explain:
suppose you are in American users add transaction entries in Web based application,
let assume entry punched @ 11.30pm on date 04 Feb 2013

Another user views report, which is located in India.
when he filters this report based on date he can not found the above entry ,

when he adds a date as 5 Feb 2013 user in india can view the entry ?

How to handle in sql please explain


Thanks in advance