how to insert SQLBase dates into SQL Server 2000?

forum.cdk (2000-2005) & forum.td.cdk (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

how to insert SQLBase dates into SQL Server 2000?

Post by NewsgroupServer » 06 Jun 2006, 00:50

 Posted by:  LEd 

Hello NG, I connected my application (1.5.1) to SQLBase and SQL Server 2000
(ODBC). I was moving some rows from SQLBase to SQL Server but my SQLBase
dates con not be inserted into SQLServer.

INSERT INTO MDB_PAYMENT (INVOICE_NO,PAYMENT_DATE,CHECK_REF, AMOUNT, NOTES)
VALUES (2,1995-02-20-00.00.00.000000,'BC-1263',2486.75,'NOTES 111' );

Can anyone help me on this? Thanks a lot

Ed

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

how to insert SQLBase dates into SQL Server 2000?

Post by NewsgroupServer » 06 Jun 2006, 14:20

 Posted by:  Martin Duty 

LEd,

It is your DateTime field that is the problem. You will have to format to
SQL Servers format before inserting.

Martin

Return to “td.cdk”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests