I have a table containing dates for events that all occurred in November. I created this query:
select id,numbers_from,created_date,amount_numbers,SMS_text
from Test_Table
where
created_date <= '2013-04-12'
Because it occurred before the date "2013-04-12," this query should return everything that occurred in month 11 (November) (in December) But it only displays accessible dates for events that occurred on days earlier than 04 (2013-04-12)
Maybe it's simply comparing the day portion. not the entire date? How can I fix this?