How to get day from date in SQL?

 
 

Share on Google+Share on Google+

Java Coder
How to get day from date in SQL?
1 Answer(s)      a year and 4 months ago
Posted in : SQL

Hi,

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

Thanks

Ads
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


Ads









Ads

 
Advertisement null

Ads