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

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

JDBC : Get year from Date

Day for the given Date in Java

python add 1 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?

Get first day of week

how to get current date without system date

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