zonkd Posted June 24, 2008 Share Posted June 24, 2008 To give the time on the 'late news' page I have echo '<span class="roja">Updated</span>: '; echo date("d/m/Y Hi"); But the difference between most visitors on this website and the server is 5 hours. What is the usual way to say minus or plus 5 hours, please, Experts? Quote Link to comment Share on other sites More sharing options...
fenway Posted June 24, 2008 Share Posted June 24, 2008 MySQL can do date math and automatically account for timezone differences. Quote Link to comment Share on other sites More sharing options...
zonkd Posted June 24, 2008 Author Share Posted June 24, 2008 I see, Fenway, thank you for pointing it out. Where can I find an example, please? Quote Link to comment Share on other sites More sharing options...
bluejay002 Posted June 26, 2008 Share Posted June 26, 2008 you can do that with DATE(). Google has a lot of results for that. Happy SQLing! Quote Link to comment Share on other sites More sharing options...
fenway Posted June 26, 2008 Share Posted June 26, 2008 CONVERT_TZ() is the function, I think. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.