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
