How to override value in NOW mysql function? I need to set past date in now function

Question

I have set up cronjob wherein MySQL query there are used NOW SQL function at lots of time. I want to run cronjob for a past date so I need to change in code. But I think if I will change return static past date value in now function of SQL then I can do a thing without code change.

My current code in cronjob.

....
$query = "SELECT * from table_name where from_date <= DATE(NOW())";
....

And what is the problem with using MySQL's date function to offset `NOW()` by some amount? — Tim Biegeleisen, May 01 '19 at 06:35
I want to override the function "NOW" to change the value with past date instead of current date. Do you have idea about it? — Bhavin Thummar, May 01 '19 at 06:36
You're looking for `INTERVAL` See: https://stackoverflow.com/questions/3887509/mysqls-now-1-day — Ultimater, May 01 '19 at 06:36
This can't be done AFAIK. Again, what is the problem with manually offsetting `NOW()` yourself? — Tim Biegeleisen, May 01 '19 at 06:36
No you have not understood my problem bro. I don't want change in code. — Bhavin Thummar, May 01 '19 at 06:38
@Ultimater Do you know about the way of override NOW function of MYSQL?? — Bhavin Thummar, May 01 '19 at 06:42
Aside, why wrap `NOW()` in `DATE()`? `NOW()` is a datetime, no conversion needed. — danblack, May 01 '19 at 06:44
NOW return "YYYY-MM-DD HH-MM-SS" format and date function change the format to "YYYY-MM-DD". so i use date() on now() function — Bhavin Thummar, May 01 '19 at 06:45
@BhavinThummar if you only want the date, use `CURDATE()` in preference to `DATE(NOW())` — Nick, May 01 '19 at 06:50

score 1 · Answer 1 · answered May 01 '19 at 06:42

1

You can set the system variable timestamp to set a time that is returned by NOW()

answered May 01 '19 at 06:42

danblack

12,130
2
22
41

You are nearer to my answer. I will check right now this thing. – Bhavin Thummar May 01 '19 at 06:44

score 0 · Answer 2 · answered May 01 '19 at 06:38

0

Why you need to override, Its not feasible? You can use past date instead of now as you specified in question!!

$query = "SELECT * from table_name where from_date <= 'yyyy-mm-dd H:i:S'";
$query = "SELECT * from table_name where from_date <= '2018-05-05 05:05:05'";

answered May 01 '19 at 06:38

Kiran

1,176
2
14
27

I am using lots of time now function in php code. So i think we can change the return value of now function in mysql. – Bhavin Thummar May 01 '19 at 06:40
Do you know about the way of override NOW function of MYSQL? – Bhavin Thummar May 01 '19 at 06:42

How to override value in NOW mysql function? I need to set past date in now function

2 Answers2