I have a server based on US Pacific TZ but the site is used in the US Eastern TZ.
So throughout all of my code I convert any times stored in the SQL tables to +3; however, I'm not sure how to handle the date.
For example, something is done on the website at 1:00 AM on 04/28/2010. When it sends the data to the database it puts 04/27/2010 10:00 PM. That, I'm fine with that it keeps doing that.
But if I want to dispaly this on the site how can I make sure that the date dispalys the 28th because if I do my timeformat of +3 to display the correct EST of 1:00 AM is there a way to dispaly the date as the 28th without adding a bunch of CF statements?
For example, the only way I can figure out how to do this is to say that if the time is after 21:00:00 then add a day to the date, else, display the date as is.