Alex - yes, you can call a function from within a SQL statement
select countBusDays(dateasgn, '#form.startdate#', '#form.enddate#')
"FUNCTION"
from dual
is one example
Brian
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 3:15 PM
To: CF-Talk
Subject: Re: [RE: SQL Business Dates]
thanks but dateasgn and datecomp will always be a business date. the
difference between them is the problem nights and weekends get included.
Question: Can I write a function in SQLServer like in PLSQL and call that
function from within an SQL query?
"Hayes, David" <[EMAIL PROTECTED]> wrote:
Look at the DATEPART function.
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 1:31 PM
To: CF-Talk
Subject: SQL Business Dates
I have a query ...
SELECT AVG(DATEDIFF(minute, dateasgn, datecomp)) AS diff
FROM tblprob
WHERE priority = 'urgent'
AND datecomp IS NOT NULL
AND status = 'closed'
AND dateasgn >= '#form.startdate#'
AND dateasgn <= '#form.endDate#'
but I only want the business dates (no weekends or nights; just 9AM to 5PM
Mon
to Fri)
This is in SQLServer. Any help appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
