That's kind of the point I was getting at. If you have a choice between
cf and sql function, go with the sql function. Another reason you want
to do this is because you want to go with one servers date/time. That
is, you're only going to work with one db, but you may be in a cluster
when it comes to your webservers, or your webserver time might be way
off (this has actually happened to me). Anyway, getdate() will get you
to where you want to go.
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 9:48 AM
To: CF-Talk
Subject: RE: Recording milliseconds
Since you are just storing the current timestamp, why are you generating
it in CF? This is a perfect example of a situation where you should let
your database do the work.
Instead of
INSERT INTO someTable (myDate)
VALUES('#Now()#')
Do
INSERT INTO someTable (myDate)
VALUES(GetDate())
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Dolan Trout [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 8:19 AM
To: CF-Talk
Subject: Re: Recording milliseconds
Mark,
Yes. I don't think the problem is with the SQL. I can't seem to find
any function or method in CF that will allow me to display the
milliseconds.
Thanks for the rapid response.
----- Original Message -----
From: Mark Stewart <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 8:11 AM
Subject: RE: Recording milliseconds
> Dolan,
>
> Have you used the getdate() SQL Server function? I believe that it
> stores milliseconds as well.
>
> Mark
>
> -----Original Message-----
> From: Dolan Trout [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 8:44 AM
> To: CF-Talk
> Subject: Recording milliseconds
>
>
> I currently have an Insert on a cfm page that stores a datetime in an
> SQL 7 database by using the Now() function. The problem is that I
> need to record
> milliseconds and the Now() function does not pass milliseconds. SQL 7
> (according to book online) will only store what is passed. If any one
> has
> some insight on this, I would greatly appciate it.
>
> Thanks,
> Dolan Trout
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
