i have date field in db.
- i want data between saturday sunday , monday .
- of data want 1 record record date next coming date
hope make self clear
select dayofweek(date) wd table wd > 1 , wd < 6 , date >= current_timestamp() order date asc limit 1;
i have date field in db.
hope make self clear
select dayofweek(date) wd table wd > 1 , wd < 6 , date >= current_timestamp() order date asc limit 1;
Comments
Post a Comment