How to get day from date in SQL?

Hi,

How to get day from date in SQL? For your information I am working on the MySQL database.

Thanks

View Answers

July 13, 2016 at 10:32 AM

Hi,

You can use the following queries to get the data:

select date_format(now(),'%e')as day;

select day(now()) as day;

Thanks









Related Tutorials/Questions & Answers:
Advertisements