[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