I have a table with start_date (date), end_date (date), rate(float) as 3 fields, I want to compare today's date with start and end date if it is inside this range then pick up the corresponding rate.
But how mysql stores dates ? (YYYY-MM-DD ?) how can i compare with today's date ? I tried some different combinations but in not successful. regards, manisha