Click here to Skip to main content
15,885,366 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I have a database of different users from different countries who had registered in our application. There might be the users having friends in different countries.

Say, there are 3 users A, B,C. A is in India, B is in San Francisco and C is in Italy and A, B, C all three are friends.

A's birthday is on 29/08/2014.
So, on 29/08/2014 at 12:00:00 AM (A's time zone), i need to send B & C the A's birthday notification via server with respect to A's time zone.

In case if i had chosen to run a scheduler everyday at 12:00:00 AM server time, it might not be the same as A's time zone. It might be few minutes before or after the A's time zone. But i need to send the notification only at A's time zone.

I need to achieve this functionality. I would be very glad if someone can please help me.

Please help me in achieving this functionality.

Thanks in advance.

Suresh
Posted

Please look here[^].
 
Share this answer
 
Make sure that all the relevant times are store as UTC values in your database. Then, when you run your reminder process you just need to compare the user entry with the current UTC time, and it will work correctly.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900