Use the createtime(hh,mm,ss) function so that CF creates a proper time
variable.
so
you can then use any if the date/time functions on these variables.
HTH
Mike
On 1/9/06, Love Sponge <[EMAIL PROTECTED]> wrote:
>
> I am developing a form where the user selects a start and end time from a
>
At 01:45 PM 9/26/02, you wrote:
>I have two date and time fields, start and end. I want find the difference
>and i want to display the difference as days:hrs:mins:secs what is the best
>way to do that... ?
>
>Right now i use hour minute and second (built in functions) and those work
>find for d
September 27, 2002 6:58 AM
> To: CF-Talk
> Subject: RE: Time calculation
>
>
> I think you want integer division: "\"
>
> > -Original Message-
> > From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, September 26, 2002 8:
I think you want integer division: "\"
> -Original Message-
> From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 26, 2002 8:26 PM
> To: CF-Talk
> Subject: RE: Time calculation
>
>
> Crap.
>
> Change all of the &
Mosh Teitelbaum wrote:
> > Got one of these for SQL Server?
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> You mean it doesn't work? You should really get a better database :-)
You mean MS Access? I don't think it'll work in that either 8^).
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 62
i use this for hr min output :
HR " &
"" & NumberFormat((DateDiff('n', StartTime, StopTime) MOD 60),'00') & " MIN">
adjust to taste.
gl,
alex
-Original Message-
From: John Gedeon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 4:45 PM
To: CF-Talk
Subject: Time calculati
t;evoch, LLC
>Tel: (301) 625-9191
>Fax: (301) 933-3651
>Email: [EMAIL PROTECTED]
>WWW: http://www.evoch.com/
>
>
> > -Original Message-
> > From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, September 26, 2002 6:32 PM
> > To:
/
> -Original Message-
> From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 26, 2002 6:32 PM
> To: CF-Talk
> Subject: RE: Time calculation
>
>
> DateDiff() by itself is not enough. It can tell you the
> difference in days
> OR hours OR ...,
John Gedeon wrote:
> I tried your sql statement in my oracle db and it said it was missing a
> right parenthesis
Oeps, sorry. start and end are reserved words and require double quotes.
With them, it works like below:
test1=# select version();
version
=
John Gedeon wrote:
> I tried your sql statement in my oracle db and it said it was missing a
> right parenthesis
Oeps, sorry. start and end are reserved words and require double quotes.
With them, it works like below:
test1=# select version();
version
_
I tried your sql statement in my oracle db and it said it was missing a
right parenthesis
At 01:35 AM 9/27/2002 +0200, you wrote:
>Mosh Teitelbaum wrote:
> > Got one of these for SQL Server?
>
>You mean it doesn't work? You should really get a better database :-)
>
>I presume the SQL Server manu
Mosh Teitelbaum wrote:
> Got one of these for SQL Server?
You mean it doesn't work? You should really get a better database :-)
I presume the SQL Server manual has a compliance list for SQL
functionality as defined in SQL:1999. You probably need to look for
workarounds for feature F052 (interv
2 5:36 PM
> To: CF-Talk
> Subject: Re: Time calculation
>
>
> John Gedeon wrote:
> > I have two date and time fields, start and end. I want find the
> difference
> > and i want to display the difference as days:hrs:mins:secs what
> is the best
> > way to d
DateDiff() by itself is not enough. It can tell you the difference in days
OR hours OR ..., but not all combined. The following (untested) code should
do what you want. My apologies if it doesn't 8^).
#d
Thanks
At 05:19 PM 9/26/2002 -0400, you wrote:
>DateDiff(datepart, date1, date2)
>
>
>
> > -Original Message-
> > From: John Gedeon [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, September 26, 2002 3:45 PM
> > To: CF-Talk
> > Subject: Time calculation
> >
> > I have two date and time field
DateDiff()? or maybe I misunderstood your question.
Nick Han
>>> [EMAIL PROTECTED] 09/26/02 01:45PM >>>
I have two date and time fields, start and end. I want find the difference
and i want to display the difference as days:hrs:mins:secs what is the best
way to do that... ?
Right now i use h
John Gedeon wrote:
> I have two date and time fields, start and end. I want find the difference
> and i want to display the difference as days:hrs:mins:secs what is the best
> way to do that... ?
>
> Right now i use hour minute and second (built in functions) and those work
> find for differen
DateDiff(datepart, date1, date2)
> -Original Message-
> From: John Gedeon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 26, 2002 3:45 PM
> To: CF-Talk
> Subject: Time calculation
>
> I have two date and time fields, start and end. I want find the
difference
> and i want to dis
18 matches
Mail list logo
