Instead of now(), use current_timestamp (I assume you were trying the
Now() function in your SQL, not the CF #Now()#)
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Dolan Trout [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 7: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
