We use the getdate() function in SQL Server to force a date on an INSERT
statement. It seems to work just fine for us and we haven't had a need
to use the CreateODBCDate() function. It uses the system clock to
create the date. I believe there is a similar getdate() function (or
the same one) in Access.
Insert Into SampleTable (datefield, otherfield) values (getdate(),
'othertext')
Ryan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Bakken, Kory
Sent: Wednesday, September 05, 2001 1:55 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] OLE DB
Daryl
If CreateODBCDate() and CreateODBCDateTime() don't always work, do you
know if there is an alternate function for OLE DB, or can you simply use
the generic CreateDate() and CreateTime() functions where those others
were previously required?
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
