CODEWITHSUNDEEP
phpmysql
Lisa
Lisa

Reputation: 416

Insert CURRENT_TIME minus 1 hour?

I have a database table with a timestamp column named "lastfed".

Does someone know how I can update that column with current time minus for example 1 hour?

$query = $db->prepare("UPDATE test SET fullness = $newFullness, lastfed = CURRENT_TIME WHERE id = ?");

Upvotes: 2

Views: 1688

Answers (2)

Rahul
Rahul

Reputation: 77866

UPDATE test 
SET fullness = $newFullness, lastfed = SUBDATE(CURDATE(), INTERVAL 1 HOUR) WHERE id = ?

Upvotes: 0

Filipe Silva
Filipe Silva

Reputation: 21657

Use date_sub()

UPDATE test 
SET fullness = $newFullness, 
    lastfed = date_sub(now(), INTERVAL 1 HOUR) 
WHERE id = ?

sqlfiddle demo

Upvotes: 4

Related Questions