Ellie,
In SQL use the getdate() function.
Dan
----- Original Message -----
From: "Elaine L" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 29, 2000 1:41 AM
Subject: RE: create a date for table
> Hi,
>
> I tried to set up the field in Microsoft SQL 7
> the datatype as dateime (or shd it be timestamp?)
> and the default value to Date()+Time() but an
> error msg came up:
>
> - Unable to modify table.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]'date' is not a
recognized function name.
>
> What's missing
>
> Thanks in advance
>
> Ellie
>
> On Thu, 29 Jun 2000 12:43:18
> Parker, Kevin wrote:
> >I just add Date()+Time() as the default value in the table - gets the
> >database to do the work, not your code. Every time a new row is added its
> >date and time stamped.
> >
> >
> >********************************
> >Kevin Parker
> >Service and Communication
> >WorkCover Corporation
> >
> >[EMAIL PROTECTED]
> >
> >ph: +61 8 82332548
> >fax: +61 8 82332000
> >********************************
> >
> >
> >-----Original Message-----
> >From: Elaine L [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, 29 June 2000 12:38:PM
> >To: [EMAIL PROTECTED]
> >Subject: create a date for table
> >
> >
> >Hi,
> >
> >Hope I am not repeating an old question.
> >
> >I need to create a field in a table (Microsoft SQL) called DateCreated.
The
> >value shd be automatically created and passed as a hidden field every
time
> >the submit page is actioned.
> >
> >What is the best way of doing this?
> >
> >Ellie
> >
> >
> >
> >
> >
> >Send FREE Greetings for Father's Day--or any day!
> >Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct
>
>---------------------------------------------------------------------------
-
> >--
> >Archives: http://www.eGroups.com/list/cf-talk
> >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.
> >
> >
> >
>
>***************************************************************************
*
> >This e-mail is intended for the use of the addressee only. It may contain
> >information that is protected by legislated confidentiality and/or is
> >legally privileged. If you are not the intended recipient you are
prohibited
> >from disseminating, distributing or copying this e-mail. Any opinion
> >expressed in this e-mail may not necessarily be that of the WorkCover
> >Corporation of South Australia. Although precautions have been taken, the
> >sender cannot warrant that this e-mail or any files transmitted with it
are
> >free of viruses or any other defect.
> >If you have received this e-mail in error, please notify the sender
> >immediately by return e-mail and destroy the original e-mail and any
copies.
>
>***************************************************************************
*
>
>---------------------------------------------------------------------------
---
> >Archives: http://www.eGroups.com/list/cf-talk
> >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.
> >
>
>
> Send FREE Greetings for Father's Day--or any day!
> Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> 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.eGroups.com/list/cf-talk
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.
