First, you should never use formated dates in SQL
Who says?
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: 09 December 2005 02:41
To: CF-Talk
Subject: Re: SQL Dates
#DATEFORMAT(NOW(),'MM/DD/')# BETWEEN PA_START_DATE AND PA_END_DATE
First, you should
/cfif
/cfoutput
-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: 09 December 2005 02:45
To: CF-Talk
Subject: RE: SQL Dates
~|
Find out how CFTicket can increase your company's customer support
First, you should never use formated dates in SQL
Who says?
Dozens of users having trouble with dates in queries evey week ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this
Then use them correctly!!! ;-)
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: 09 December 2005 14:42
To: CF-Talk
Subject: Re: SQL Dates
First, you should never use formated dates in SQL
Who says?
Dozens of users having trouble with dates in queries evey
Perish the thought sir; perish the very thought.
Robertson-Ravo, Neil (RX) wrote:
Then use them correctly!!! ;-)
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: 09 December 2005 14:42
To: CF-Talk
Subject: Re: SQL Dates
First, you should never use formated
#DATEFORMAT(NOW(),'MM/DD/')# BETWEEN PA_START_DATE AND PA_END_DATE
First, you should never use formated dates in SQL, especially if you
want to compare them with columns.
And most especially with the month first.
If PA_START_DATE and PA_END_DATE are true date type, try this:
WHERE
Try cfqueryparam value=#now()# cfsqltype=CF_SQL_TIMESTAMP
That will give you the db-independence.
-Original Message-
From: ColdFusion [mailto:[EMAIL PROTECTED]
Sent: Friday, 9 December 2005 3:31 p.m.
To: CF-Talk
Subject: SQL Dates
I am trying to get all records from a table where the
Thanks.. I knew it was something simple.. Just could not see it.
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 08, 2005 9:41 PM
To: CF-Talk
Subject: Re: SQL Dates
#DATEFORMAT(NOW(),'MM/DD/')# BETWEEN PA_START_DATE AND PA_END_DATE
8 matches
Mail list logo