[Jprogramming] How to insert SQL server datetime

[Anssi Seppälä]

There is also bulk insert ddins and same errors again. Could somebody give another example for SQL server ?
Anssi

-----Original Message-----
From: programming-bounces at forums.jsoftware.com [mailto:programming-bounces at forums.jsoftware.com] On Behalf Of Anssi Seppälä
Sent: 30. toukokuuta 2013 22:09
To: programming at jsoftware.com
Subject: Re: [Jprogramming] How to insert SQL server datetime

Thanks. 

-----Original Message-----
From: programming-bounces at forums.jsoftware.com [mailto:programming-bounces at forums.jsoftware.com] On Behalf Of Lippu Esa
Sent: 30. toukokuuta 2013 14:08
To: 'programming at jsoftware.com'
Subject: Re: [Jprogramming] How to insert SQL server datetime

Hello Anssi,

is this what you need (ch is an open odbc connection handle):

'create table #a(b datetime)' ddsql ch

'insert #a values (''20130529 14:04:01.11'')' ddsql ch

Esa

-----Original Message-----
From: programming-bounces at forums.jsoftware.com [mailto:programming-bounces at forums.jsoftware.com] On Behalf Of Anssi Seppälä
Sent: 30. toukokuuta 2013 9:33
To: programming at jsoftware.com
Subject: [Jprogramming] How to insert SQL server datetime

Can anyone please post an example how to insert datetime values into a MS SQL Server table using J 6.02 ODBC library?
I am stuck with Bad arguments error message.

Thanks,
Anssi
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm