| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Date Manipulation Question|
| 6:28 pm on Mar 2, 2005 (gmt 0)|
I am currently using the NOW() variable in MySQL to generate a date that looks something like this:
My question is, how do I create a time that is 5 hours in the past? The time zone is too far ahead, thanks in advance,
| 7:49 pm on Mar 2, 2005 (gmt 0)|
SELECT DATE_SUB(NOW(), INTERVAL 5 HOUR)
SELECT NOW() - INTERVAL 5 HOUR
Hope this helps =)
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved