Need some locale advice.
Need to reach out to the community here for some help.
My current project coming up involves taking a couple of websites and merging them so that run off one centralized database and site. This kinda like what Instantspot and about 1000 other websites do (including wordpress!). The issue is that the current sites are all over the country so obviously I’m going to have to display the date and time for that site’s current timezone.
The question is how would take the timestamp that is currently stored in the database and convert it to UTC time? What is the best way to go about doing this. Are there any CFCs out there that could take care of this for me.