February 5th, 2013, 07:21 AM
|
|
Contributing User
|
|
Join Date: Oct 2003
Location: Germany
|
|
Quote: | Originally Posted by alphak01 You can make a query like this: |
That query is unnecessary complicated. It can be rewritten as:
Code:
SELECT *
FROM Calls
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.
DATE '2013-01-01' 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)
Quote: | 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.
http://forums.devshed.com/misc.php?do=bbcode#code
Tips on how to ask better questions:
http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
http://wiki.postgresql.org/wiki/SlowQueryQuestions
http://catb.org/esr/faqs/smart-questions.html
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
