jwk811 Posted December 16, 2006 Share Posted December 16, 2006 how can i make the NOW(); function be in my time and also not in military time? do i have to use the date(); function instead? Quote Link to comment Share on other sites More sharing options...
fert Posted December 16, 2006 Share Posted December 16, 2006 I think you do have to use date. Quote Link to comment Share on other sites More sharing options...
bljepp69 Posted December 16, 2006 Share Posted December 16, 2006 If you can't change the time of the mySQL server, try using the CONVERT_TZ() function.CONVERT_TZ(NOW(),from_tz,to_tz) 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.