WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

How to subtract days from a date in MySQL?

Themoose

New member

0

0%

Status

Offline

Posts

37

Likes

0

Rep

0

Bits

195

3

Months of Service

0%
After running the SQL query "SELECT date_format(CURDATE(),'%d %m %Y %W') as ddd," I am getting the output "07 11 2017 Tuesday." What I want is to only extract the "Tuesday" part. In other words, I just want to find out which day corresponds to the input date. What should I do for this?
 

249

6,622

6,642

Top