My problem is, I need to make accommodation for the Server's time being different than EST, which is the time zone the client relies on for announcement scheduling. My server is in Arizona, so there's a 3 hr. difference.
My SELECT statement currently looks like:
Code: Select all
SELECT id, headline, subhead, date_format(date, '%M %D, %Y') as displaydate FROM newsreleases WHERE YEAR(date)=$currentYear AND date <= NOW() ORDER BY date DESCThanks,
max