Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
mysql select month and year
Joe Hayes
Programming language:
SQL
2021-05-16 21:21:01
0
Q:
mysql select month and year
jasmine
Code:
SQL
2021-08-06 22:57:41
SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;
0
Tags
mysql
sql
select
Related
mysql last friday of current month
mysql get day of week
mysql get date diff in months
mysql month name extract
date_part mysql
mysql where one year ago
get records in sql according to month name and count
mysql select date from datetime
mssql last day of month
mysql extract month from date
monthname sql
mysql query date year
get month from date in sql server
mysql extract month
sql get month name
month mysql
mysql get last 2 month data
New to Communities?
Join the community