How to subtract hours from a datetime in MySQL?

by

mySQL has DATE_SUB():

SELECT DATE_SUB(column, INTERVAL 3 HOUR)....

but would it not be better to try and sort out the underlying time zone issue instead?

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. How do you set a default value for a MySQL Datetime column?
  3. MySQL Query GROUP BY day / month / year
  4. Error in MySQL when setting default value for DATE or DATETIME
  5. How to group by week in MySQL?
  6. Difference between two dates in MySQL
  7. MySQL Query to select data from last week?
  8. MySQL convert date string to Unix timestamp
  9. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  10. How to store a datetime in MySQL with timezone info
  11. How to select date from datetime column?
  12. Datetime equal or greater than today in MySQL
  13. How to convert number of week into date?
  14. Set NOW() as Default Value for datetime datatype?
  15. Group mysql query by 15 min intervals
  16. SQL Query to show nearest date?
  17. How to convert time to the time zone of the iPhone device?
  18. Select data between a date/time range
  19. mysql: get record count between two date-time
  20. MySql difference between two timestamps in days?
  21. How to cast DATETIME as a DATE in mysql?
  22. How to get current date & time in MySQL?
  23. how to cast the hexadecimal to varchar(datetime)?
  24. How to compare timestamp dates with date-only parameter in MySQL?
  25. how to partition a table by datetime column?
  26. Get total hours worked in a day mysql
  27. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  28. MySQL: Insert datetime into other datetime field
  29. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment