Mysql previous date

Question

I am using the following to have the previous date data at 00.00.00

select * from perf where timeStamp="SUBDATE(CURDATE(),1)";

But that doesn't lead to an exit

where as

select * from perf where timeStamp="2014-11-28";

the result is correct output

Can any of you please help me in trying to figure out the problem. Any help is greatly appreciated.

+3

date sql mysql datetime select

user3607869 02 dec. 14 at 6:56

source to share

3 answers

Saharsh shah · Answer 1 · 2014-12-02T06:58:21+0000

Check the SUBDATE () Function

Try the following:

SELECT * 
FROM perf
WHERE DATE(timeStamp) = SUBDATE(CURDATE(), INTERVAL 1 DAY);

Girish · Answer 2 · 2014-12-02T06:58:46+0000

1st no need to quote by function SUBDATE()

and you need to subtract 1 day

select * from perf where timeStamp=SUBDATE(CURDATE(),1);

// or with input interval details like HOURS

'DAY', 'MONTH', etc.

select * from perf where timeStamp=SUBDATE(CURDATE(),INTERVAL 1 DAY);

baao · Answer 3 · 2014-12-02T06:58:49+0000

timeStamp="SUBDATE(CURDATE(),1)";

Searches for the string "SUBDATE (CURDATE (), 1)" and the count is not correct

remove the "" and it should work like this:

select * from perf where timeStamp= SUBDATE(CURDATE(),INTERVAL 1 DAY);