In Access, you can set the datatype to date/time and the default value to
Date(). Typically it's better to let a database handle that type of function
instead of ColdFusion, but with low site traffic I don't know that it makes
any difference.
Regards,
Marc Garrett
----- Original Message -----
From: "HappyToad.com" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 26, 2000 4:07 PM
Subject: RE: Date Timestamp??
> Access. I have it working ok with the #Now()# input. Is this a problem?
>
> Rich
>
> -----Original Message-----
> From: Marc Garrett [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 26, 2000 1:44 PM
> To: CF-Talk
> Subject: Re: Date Timestamp??
>
>
> Wouldn't it be better to let the database handle it instead of CF? Which
> database are you using Rich?
>
> Regards,
>
> Marc Garrett
>
> ----- Original Message -----
> From: "Larry Juncker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 26, 2000 11:32 AM
> Subject: RE: Date Timestamp??
>
>
> > If you are wanting to put the current date and time try this:
> >
> > #CreateODBCDateTime(Now())#
> >
> > That will insert the current date and time as a timestamp
>
>
> --------------------------------------------------------------------------
--
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
