I don't know about a true timestamp but MSSQL7 has numerous date/time
functions that do return milliseconds. However, you're right when you state
that a UUID would be better suited to uniqueness.
> I haven't really been watching CF-Talk that closely lately, so I may be
> missing some info here, but...
>
> If you are in need of a random and unique ID, I would suggest using the
> CreateUUID() function, not a timestamp. It is unique across the universe
> and is only 35 characters long. Also, if you actually store this as a
date
> stamp in a database (which I'm not sure you are doing), I recall reading
> that SQL 7 (and probably other RDBMS platforms as well) don't store date
> stamps with millisecond precision, so the chances of dups would be much
> higher.
>
> -Cameron
>
> --------------------
> Cameron Childress
> ElliptIQ Inc.
> p.770.460.7277.232
> f.770.460.0963
>
> > -----Original Message-----
> > From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 11, 2000 1:37 PM
> > To: CF-Talk
> > Subject: RE: [slightly ot: math question, needed for cold fusion
> > programming]
> >
> >
> > okay, that sounds good
> >
> > so the chances of two people getting the same timestamp is the same as
the
> > packers making it to the superbowl.
> >
> > pretty much impossible.
> >
> > i'll put that in my report (using timestamp (thanks to whomever
suggested
> > that awhile back) to create a series of random 60 digit numbers, and
their
> > can never be duplicates).
> >
> > Thanks!
> > Gavin
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 11, 2000 12:21 PM
> > To: CF-Talk
> > Subject: Re: [slightly ot: math question, needed for cold fusion
> > programming]
> >
> >
> > 1.4884 x 10^19
> >
> > Gavin Myers <[EMAIL PROTECTED]> wrote:
> > Lets say you have 1 page that scores 1,000,000 unique visitors a month
> >
> > here's what I came up with:
> >
> > 1,000,000/30/24/60/60/1000 = 0.000385
> >
> > So that means that 0.0003 people a milisecond hit the sight, correct?
> > what is the % chance of 2 people hitting on the same milisecond (and
math
> > equation for that?)
> > ------------------------------------------------------------------
> > ----------
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the
> > body.
> >
> >
> > ____________________________________________________________________
> > Get free email and a permanent address at http://www.netaddress.com/?N=1
> > ------------------------------------------------------------------
> > ----------
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> > ------------------------------------------------------------------
> > ------------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
