February 5th, 2013, 08:21 AM
Join Date: Oct 2003
Originally Posted by alphak01
You can make a query like this:
That query is unnecessary complicated. It can be rewritten as:
WHERE date_column BETWEEN DATE '2013-01-01' AND DATE '2013-02-05'
There is no need for all that date to string to date conversion if you use a standard date literal.
is a "date literal". Due to the "DATE" keyword, no format mask is required (because the date literal is defined as using the ISO date format YYYY-MM-DD)
Originally Posted by Nibur
a column that is named date
That is a bad choice for a column name. Because
a) it doesn't mean anything. It doesn't tell anyone looking at your database what it is actually about. Is that a "registration date", an "end date", a "due date", a "start date", ....?
b) date is a reserved word and should not be used for identifiers.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions: