How to get day from date in SQL?

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

Ads









Related Tutorials/Questions & Answers:
How to get day from date in SQL?
How to get day from date in Java using Calendar?
Advertisements
How to get the Day name
How to get month name from date(like-25/06/2012) using java?
how to get date format in string from date object containing real date in java
how to get date format in string from date object containing real date in java
How to get day of week in Java?
JDBC : Get year from Date
How to get the current date in Java?
How to get max date in Hibernate?
Java Get Method
get data between date from msaccess database
How to get yesterday date in Python?
Get first day of week
How do I learn Java programming in one day from zero?
How do I learn Java programming in one day from zero?
Java Get Month from Date
Java get year from date
How to save and get value from JSP
Java date add day
Java get Next Day
Java subtract days from date
Java subtract years from date
Java subtract months from date
Java current date - How to get current date in Java
How to get hibernate configuration from sessionfactory?
java how to get domain name from url
How to get country locale from a http request
how to get selected name from combo box
how to get selected name from combo box
how to get selected name from combo box

Ads