MySQL Forums :: General :: Time Manipulation In Query
Re: Time Manipulation In Query
Posted by: newbie Shai ()
Date: November 28, 2011 07:52PM
Dear Rick,
Thank you for all your knowleedge. Beside that I would like to ask something bit more complex. I have this statement "Where ScvData.dateTimer BETWEEN '2011-10-19 00:00:00' - INTERVAL '+08:00' hour_minute AND '2011-10-20 23:59:59' - INTERVAL '+08:00' hour_minute". First I would like to minus '-08:00' cause the server time is '+08:00'. Theereafter only I would like to add the GMT accordingly? How best to solve this?
Thank you for all your knowleedge. Beside that I would like to ask something bit more complex. I have this statement "Where ScvData.dateTimer BETWEEN '2011-10-19 00:00:00' - INTERVAL '+08:00' hour_minute AND '2011-10-20 23:59:59' - INTERVAL '+08:00' hour_minute". First I would like to minus '-08:00' cause the server time is '+08:00'. Theereafter only I would like to add the GMT accordingly? How best to solve this?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates