Changes between Initial Version and Version 1 of Ticket #24959
- Timestamp:
- Jun 8, 2015, 9:17:59 PM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #24959 – Description
initial v1 10 10 11 11 {{{ 12 UPDATE ` scheduling_event`12 UPDATE `my_table` 13 13 SET ... 14 14 `my_datetime` = (`my_table`.`my_datetime` + INTERVAL '-1 0:0:82800:0' DAY_MICROSECOND), … … 20 20 21 21 {{{ 22 UPDATE ` scheduling_event`22 UPDATE `my_table` 23 23 SET ... 24 24 `my_datetime` = (`my_table`.`my_datetime` + INTERVAL '-0 0:0:3600:0' DAY_MICROSECOND), … … 28 28 In layman's terms - the two layers are not convertible in a one-to-one sense. A `timedelta` in for the example above in Python means: '''go back one day and *add* 23 hours'''. So some `datetime + delta` would just subtract one hour. 29 29 30 In MySQL, however, "INTERVAL '-1 0:0:82800:0' DAY_MICROSECOND)"means: '''add a negative one day and 23 hours'''.30 In MySQL, however, ''"INTERVAL '-1 0:0:82800:0' DAY_MICROSECOND)"'' means: '''add a negative one day and 23 hours'''.