Is it possible to add a datetime field value such as I know how it will work in PHP but I want to do it through query. Any help would be appreciated. I think what you want MySQL date_add () function - For example, DATE_ADD ('2013-06-22 09:46:00', INTERVAL 1 day), where you can change the date-time and day intervals along with the respective column names. Update Let us assume, the date time zone is called FIELDA and if the integer field is called FIELDB, represent the day, the function can be called as Is: If the integer field represents hour, then you call it: Hope above helps! 2013-06-22 09:46:00 One or more integer field values such as
1 (indicates day column)
2 (indicates hour column) then after adding the datetime value to the result integer Receives should be in datetime form so that I can compare it with any other Datat field value. Like if I get the result after adding the integer field
2013-06-23 11:46:00 , then I want to compare it to another datat field value, so that the value of the result is bigger The comparative price will only result in me.
DATE_ADD (FIELDA, interval field day);
DATE_ADD (FIELDA, INTERVAL FIELDB HOUR);
No comments:
Post a Comment