How do I write this MySQL Query? (datetime)

Posted by alex on Stack Overflow See other posts from Stack Overflow or by alex
Published on 2010-03-30T08:41:31Z Indexed on 2010/03/30 8:43 UTC
Read the original article Hit count: 292

Filed under:
|

Suppose I have a DateTime field called "time_before"

I want to insert a datetime that is 1 hour before the now() time.

INSERT INTO mytable(time_before) VALUES(now()-3600 seconds)...something like this, right?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about database