macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: SQL dates

Subject: Re: SQL dates
From: "trojnfn"
Date: Mon, 13 Aug 2007 20:34:34 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
The start date unformattted is  2007-08-01 10:02:16.0 and the end_date 
unformatted is 2007-08-03 08:29:30.0  and the date diff calculation comes out 
to  1 and it should be 2 ?

 Here is the date diff : 
#datediff('d',qryGet_Report.start_date,qryGet_Report.end_date)#


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