Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from my_table
- where year(my_date_col) = 2018
- and month(my_date_col) = 1
- SELECT *
- FROM my_table
- WHERE my_date_col >= '2018-01-01'
- AND my_date_col <= '2018-01-31'
- SELECT *
- FROM my_table
- WHERE my_date_col >= '2018-01-01'
- AND my_date_col <= LAST_DAY('2018-01-01')
Add Comment
Please, Sign In to add comment