[thelist] CF Timestamp in a hidden input
Palyne Gaenir
palyne at sciencehorizon.com
Wed Jul 19 17:14:38 CDT 2000
Hi Rudy,
In SQL-Server it's GETDATE(), but the problem is, what if I want to
pass that value like the poster earlier did -- in a CFSET or a
CFPARAM in the page, as opposed to directly in the insert/update?
Now() gets the USER's now. GETDATE() is for the db. Is there a way
to say "now" for the "system" in a CFSET/CFPARAM? Palyne
> instead of passing in the cf server's date
> insert into thetable values ( ... #Now()# ... )
> just use
> insert into thetable values ( ... current date ... )
> obviously, the reserved word "current date" will vary from database to
> database, so you gotta look it up
More information about the thelist
mailing list