Hello,
I am receiving from a remote server a time in the format "2016-06-30T09:30:000-7000" for appointments. This is being saved in a database table on the server where my website is hosted so a time zone that is several hours difference I believe it current is 1 hour west of Greenwich, UK. Part of this issue is that the hosting company could move my website to another location/timezone without making me aware of this. In any case, I need to have a cron job that runs and looks at the database to find any times that are within 15 to 20 minutes of the current time on the server. I am just not sure if the format of the datetime when I put it in the database would require adjusting the datetime to a different time so that I can send a reminder to the person according to their local date/time. I would appreciate some clarification on what I need to do and how I would actually do that. I have a mySQL database and am using PHP to create the SELECT Query. I could hopefully write a UPDATE if the time needs to be converted.
I would just need to know what really needs to be done. This is just bit confusing to me as I don't know how the datetime on the server would coordinate with the datetime in the database.
Thanks for any help in understanding this more clearly and for any assistance in what I actually need to do.
Kim
