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