Hi, I'm a little new to PHP and symfony, and I'm trying to determine the best overall approach to deal with timezones for my app.
I'm building an app where one set of users enter an event booking time in their local time. Another set of users offer to provide a service at the designated booking time. They also specify a required notification period, such as 2 hours before the booking time. The way I have in mind to solve this would be as follows: 1) Store event booking times in my MySQL database in EST, and also store the offset from the user's local time. 2) When the user attempts to book a service provider, take the current time at EST, and see if it is within the notification period. What I am a little confused about is how to do this: 1) I'm using Propel. I'd like to be able to store my timestamps in MySQL in EST, even if I don't have access to mysql settings (as I don't know who will be my hosting company yet) 2) What are the best API's to use for converting between timezones. I was looking at date_default_timezone_set(), but I need to look into the side effects. 3) If I am going to use a standard timezone (eg: to EST), should I do it right in my front controller? Thanks for your help. Steve --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
