| select DATE_FORMAT(CURDATE(), '%M_%Y') |
3 years ago |
| select DATE_FORMAT(CURDATE(), '%Y_%M') |
3 years ago |
| select DATE_FORMAT('%Y_%M', CURDATE()) |
3 years ago |
| select CONCAT('%', DATE_FORMAT('%Y_%M', CURDATE())) |
3 years ago |
| select '%' + DATE_FORMAT('%Y_%M', CURDATE()) |
3 years ago |
| select '%' + CAST(MONTHNAME(CURDATE()) AS varchar) + '_' +... |
3 years ago |
| select '%' + CAST(MONTHNAME(CURDATE()) AS varchar) + '_' + YEAR(CURDATE()) |
3 years ago |
| select '%' + CAST(MONTHNAME(CURDATE()) AS string) + '_' + YEAR(CURDATE()) |
3 years ago |
| select '%' + MONTHNAME(CURDATE()) + '_' + YEAR(CURDATE()) |
3 years ago |
| select MONTHNAME(CURDATE()), YEAR(CURDATE()); |
3 years ago |
| select MONTHNAME(CURDATE()); |
3 years ago |
| select MONTHNAME(CURRENTTIME()); |
3 years ago |
| select MONTHNAME( GETDATE() ); |
3 years ago |
| select MONTHNAME("2017-05-15"); |
3 years ago |
| select MONTHNAME("2017-06-15"); |
3 years ago |
