Hi, Friday, January 17, 2003, 11:16:53 AM, you wrote: S> I have a PHP driven site that as a time schedule. Since the site isn't exactly filled with very intellagent people who just LOVE to translate times and dates from a weird format (Such as the S> format used in MySQL), I'd like to take these from a MySQL table (the table's types are DATE and TIME) and translate the date to something like "Thrusday, January 16th, 2003" when the date strate S> from the table is "2003-01-16." Then with time, I'd like it to read something like "8:00 PM" when it reads straight from the table "20:00:00." Another feature I'd like to have it timezones but S> that's not the point of this message. If you don't mind, though, could you also tell me how to configure the times according the the timezone a user has chosen?
S> Thanks, S> Stephen Craton S> http://www.melchior.us S> "What's the point in appearance if your true love, doesn't care about it?" -- http://www.melchior.us What you could do is use javascript to get the clients local time, compare it with the server time and get a difference. Then get all dates from mysql as a unix timestamp, apply the difference then use date() to format it as you want and it will always match the clients time on their computer...even if they have it wrong :) -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
