RE: How do u insert data/time in SQL 2000

2002-01-28 Thread Joseph DeVore 

Pardeep,

Use the GetDate() function and make sure ALLOW NULLS is *not* checked.

HTH,

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 11:09 PM
To: CF-Talk
Subject: Re: How do u insert data/time in SQL 2000


In SQL 2000, what code do you type in the default field so that the current
date and time is inserted into a field.

I have one field for DATE and another for TIME so we know the date and time
a form was submitted.

Thanks.

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do u insert data/time in SQL 2000

2002-01-28 Thread Paul Hastings 

> I have one field for DATE and another for TIME so we know the date and
time
> a form was submitted.

use one datetime column in your table & stay away from cfinsert/cfupdate.
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do u insert data/time in SQL 2000

2002-01-28 Thread one 

In SQL 2000, what code do you type in the default field so that the current
date and time is inserted into a field.

I have one field for DATE and another for TIME so we know the date and time
a form was submitted.

Thanks.
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists