i have a table in DB store the value of date format (log_date) as yyyy/mm/dd, now i would like to select the data which log_date month is September. So how is the SQL select statement look like? :confused:
Printable View
i have a table in DB store the value of date format (log_date) as yyyy/mm/dd, now i would like to select the data which log_date month is September. So how is the SQL select statement look like? :confused:
Try
SELECT *
FROM <table>
WHERE date LIKE '%/09/%'