Databse table-
id created_date timer status
1 2013-02-25 16:40:45 1 Y
2 2013-02-25 16:40:45 2 Y
3 2013-02-25 16:40:45 0 Y
This is my database table.
created_date
field is datetime
and timer
is varchar
value (integer value
)
what I want is to set status N
for every day at 12:00 AM
and when timer value is not 0
then set status=N
by adding timer+created_date
, all status change to N
at 12:00 AM
weather timer set or not.