January 24th, 2013, 05:05 AM
|
|
Contributing User
|
|
Join Date: Oct 2003
Location: Germany
|
|
Quote: | Originally Posted by dibblejon invoice_date (which is a datetime field) | Postgres does not have a "datetime" data type. Do you mean "timestamp"?
Quote: | Originally Posted by dibblejon Is equal to the currentdate? | Something like this?
Code:
where cast(invoice_date as date) = current_date
More details in the manual: http://www.postgresql.org/docs/current/static/functions-datetime.html
__________________
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
