[Top] [All Lists]

Re: Why no CF Date() function?

Subject: Re: Why no CF Date() function?
From: "jkgiven"
Date: Thu, 9 Aug 2007 18:40:00 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
I'm not really qualified to answer this question, but let me throw this in just 
in case it helps.
 I recently had to write a query that pulled only the date and no time. My 
where clause is: WHERE startDate <= CONVERT(varchar(10), getdate(), 101)

 the 101 is a code that puts it in mm/dd/yy format - no time
 If I had used 108 it would have given me hh:mm:ss - no date

 I found this in the SQL help when I looked for CONVERT

<Prev in Thread] Current Thread [Next in Thread>