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









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 day of week in Java?
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
JDBC : Get year from Date
Day for the given Date in Java
python add 1 day to date
python add one day to date
python add one day to date
Get Last Day of The Month
ModuleNotFoundError: No module named 'sqlt'
ModuleNotFoundError: No module named 'sqlu'
ModuleNotFoundError: No module named 'sqlx'
ModuleNotFoundError: No module named 'sqly'
How do I learn Java programming in one day from zero?
How do I learn Java programming in one day from zero?
Get first day of week
how to get current date without system date
ModuleNotFoundError: No module named 'sqlf'
ModuleNotFoundError: No module named 'sqlf'
get data between date from msaccess database
Java Get Month from Date
Java Get Method
How to get the current date in Java?
PHP Date add 1 day
How to get max date in Hibernate?
Get date data type from table
Java get year from date
How to get yesterday date in Python?
Java date add day
Java get Next Day
Find the Day of the Week
JSP:How to get year of system date - Date Calendar
ModuleNotFoundError: No module named 'sqlg'
Java subtract days from date
Java subtract months from date
Java subtract years from date
SQLl query count and group by
Current Date iPhone SDK
Determining the Day-of-Week for a Particular Date
GET DATE in JDBC
Mysql Date Minus Days
how to format date from yyyy-mm-dd to dd-mm-yyyy
how to prevent user selecting past date from calender
Java current date - How to get current date in Java
Mysql Date from Date
How to save and get value from JSP

Ads