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
