thanks for all your help guys, i got it sorted,
Lisa
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2002 16:18
To: CF-Talk
Subject: Re: CreateDateTime function??
John Morgan wrote:
> Good point. My method would make the data more readable in
John Morgan wrote:
> Good point. My method would make the data more readable in the database but
> your method would be more flexible.
More readable? The copy-pasted example below uses some non-standard
extensions like week and century, but you will get the point:
test=# create table ivtest (te
Good point. My method would make the data more readable in the database but
your method would be more flexible.
-John-
At 04:54 PM 12/18/2002 +0100, you wrote:
>John Morgan wrote:
> > In light of this new information my original suggestion still stands. If
> > you format your data as a string (E
John Morgan wrote:
> In light of this new information my original suggestion still stands. If
> you format your data as a string (EX: ww:dd:hh:mm) then it will sort
> correctly (assuming you zero pad 3 = 03) and pure string comparison will
> yield correct results. ( "00:03:11:15" GT "00:03:11:25
t searches
>etc can be carried out on this information for comparison.
>Thanks for the help so far,
>Lisa
>
>-Original Message-
>From: Joe Eugene [mailto:[EMAIL PROTECTED]]
>Sent: 18 December 2002 04:27
>To: CF-Talk
>Subject: RE: CreateDateTime function??
>
>
Lisa Donnelly wrote:
>
> My intention is to allow a user to select 'how long' eg, months, weeks,
> days, hours, minutes, it took to solve a problem, this information will then
> be stored as one field in the database. It is the intention that searches
> etc can be carried out on this information f
Thanks for the help so far,
Lisa
-Original Message-
From: Joe Eugene [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2002 04:27
To: CF-Talk
Subject: RE: CreateDateTime function??
> Why add a date if you want to store an interval? I mean, if you want to
> calculate a new date it is the ob
inal Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 17, 2002 6:58 PM
> To: CF-Talk
> Subject: Re: CreateDateTime function??
>
>
> Joe Eugene wrote:
> > All you need is create a default date and use function
> DateAdd("
Joe Eugene wrote:
> All you need is create a default date and use function DateAdd("",defaultDate)
> and create whatever..date you want. Check previous post for code.
Why add a date if you want to store an interval? I mean, if you want to
calculate a new date it is the obvious route, but the requ
All you need is create a default date and use function DateAdd("",defaultDate)
and create whatever..date you want. Check previous post for code.
Joe
On Tue, 17 Dec 2002 23:51:57 +0100 Jochem van Dieten <[EMAIL PROTECTED]>
wrote:
> Lisa Donnelly wrote:
> > I'm new to CF and I have hit a wall.
> >
Lisa Donnelly wrote:
> I'm new to CF and I have hit a wall.
> I have 4 select lists (numeric);
> Weeks
> Days
> Minutes
> Hours
> and I need the user to select a value from each of these lists. The problem
> is, how to store the selected values into one field of my database?
In an interval field,
For what you are doing a date field does not seem appropriate. If you
really want to store the data in a single field I would store it as a
delimited string. (EX; ww:dd:mm:hh) You would then use the list functions
*(EX: ListGetAt() ) to extract the data.
-John-
At 06:17 PM 12/17/2002 +, yo
You have 4 select dropdowns and one of them Days?
You divide days/7 to get weeks. If the user selects weeks, then no of days
you can do some like
This should work for you.
Joe
On Tue, 17 Dec 2002 18:17:11 - Lisa Donnelly
<[EMAIL PROTECTED]> wrote:
> I'm new to CF and I have hit a w
Lisa,
What are you going to do with the result. You can't construct a date from
this information, unless you are adding or subtracting from another date,
such as Now().
Andy
-Original Message-
From: Lisa Donnelly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 12:17 PM
To: C
If your intent is to use "Weeks" as in the "Nth week of the year", just
use DateAdd. Then do 3 more dateAdds for the days, mins, and hours.
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Email: [EMAIL PROTECTED]
convert your weeks into days and then use CreateDateTime()
1 week = 7 days ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Part
12 PM (noon) is 12:00
12 AM (midnight) is 00:00
--- Brook Davies <[EMAIL PROTECTED]> wrote:
> When using the createdatetime() function, the format must use a 24 hour
>
> clock right?
>
> I'm a wee bit confused, how do you show 12am and 12pm. Isn't 12AM 24:00
>
> hours?? I get an error when
st 02, 2002 6:30 PM
BFH> To: CF-Talk
BFH> Subject: Re: createdatetime(??)
BFH> stas wrote:
>> I don't think there's 24:00. It goes from 23:59 to 00:00
BFH> According to ISO 8601 the moment 2002-08-02T24:00:00 is the same as
BFH> 2002-08
Misunderstood you then :)
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 6:49 PM
To: CF-Talk
Subject: Re: createdatetime(??)
Bryan F. Hogan wrote:
> MM Reference clearly states times are from 00:00:00 to 23:59:59.
That'
Bryan F. Hogan wrote:
> MM Reference clearly states times are from 00:00:00 to 23:59:59.
That's why I specifically refered to the appropriate international
standards and not to what CF does.
On a related note, 23:59:60 is a correct time in UTC once every few
years to correct for the difference
MM Reference clearly states times are from 00:00:00 to 23:59:59.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 6:30 PM
To: CF-Talk
Subject: Re: createdatetime(??)
stas wrote:
> I don't think there's 24:00. It goes fro
stas wrote:
> I don't think there's 24:00. It goes from 23:59 to 00:00
According to ISO 8601 the moment 2002-08-02T24:00:00 is the same as
2002-08-03T00:00:00 so it should work.
IRLYMMV
Jochem
__
Your ad could be here. Monies
This should work for you..
Hour =0-23 format. ie (08/02/2002 12.15am)..
Joe
- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 5:40 PM
Subject: createdatetime(??)
> When using the createdatetime() function, t
I don't think there's 24:00. It goes from 23:59 to 00:00
- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
When using the createdatetime() function, the format must use a 24 hour
clock right?
I'm a wee bit confused, how do you show 12am and 12pm. Isn't 12AM 24:00
hours?
02, 2002 5:56 PM
>To: CF-Talk
>Subject: RE: createdatetime(??)
>
>
>The quotes work okay, with any combination other than "24" as the hour. As
>soon as I put 24 in, it fails.
>
>
>At 10:31 PM 02/08/02 +0100, you wrote:
> >Try taking out the quotes, I don&
:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 5:46 PM
To: CF-Talk
Subject: Re: createdatetime(??)
I think it needs to be from 0 to 23 for the hour.
Phillip Broussard
Tracker Marine Group
417-873-5957
- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: &
24 isn't a valid 24 hour clock hour. midnight is 00:00:00. just before it
comes 23:59:59.
chris olive.
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 5:56 PM
To: CF-Talk
Subject: RE: createdatetime(??)
The quotes work okay, wit
ED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, August 02, 2002 4:55 PM
>Subject: RE: createdatetime(??)
>
>
> > The quotes work okay, with any combination other than "24" as the hour. As
> > soon as I put 24 in, it fails.
> >
> &g
Time goes from 00:00:00 to 23:59:59 ...
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 2:56 PM
To: CF-Talk
Subject: RE: createdatetime(??)
The quotes work okay, with any combination other than "24" as the hour. As
soon as I put
I think it needs to be from 0 to 23 for the hour.
Phillip Broussard
Tracker Marine Group
417-873-5957
- Original Message -
From: "Brook Davies" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 4:55 PM
Subject: RE: create
The quotes work okay, with any combination other than "24" as the hour. As
soon as I put 24 in, it fails.
At 10:31 PM 02/08/02 +0100, you wrote:
>Try taking out the quotes, I don't think you need them. 12am is midday, 12pm
>is 24:00...
>
>I think :O)
>
>Ade
>
>-Original Message-
>Fr
Try taking out the quotes, I don't think you need them. 12am is midday, 12pm
is 24:00...
I think :O)
Ade
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2002 22:40
To: CF-Talk
Subject: createdatetime(??)
When using the createdatetime() function, t
32 matches
Mail list logo