Re: [Jprogramming] How to insert SQL server datetime

2013-06-01 Thread Anssi Seppälä
:09 To: [email protected] Subject: Re: [Jprogramming] How to insert SQL server datetime Thanks. -Original Message- From: [email protected] [mailto:[email protected]] On Behalf Of Lippu Esa Sent: 30. toukokuuta 2013 14:08 To: 'pro

Re: [Jprogramming] How to insert SQL server datetime

2013-05-30 Thread Anssi Seppälä
Thanks. -Original Message- From: [email protected] [mailto:[email protected]] On Behalf Of Lippu Esa Sent: 30. toukokuuta 2013 14:08 To: '[email protected]' Subject: Re: [Jprogramming] How to insert SQL server datetime H

Re: [Jprogramming] How to insert SQL server datetime

2013-05-30 Thread Lippu Esa
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: [email protected] [mailto:[email protected]

Re: [Jprogramming] How to insert SQL server datetime

2013-05-30 Thread bill lam
Ms sqlsvr should regard datetime as literal. Please google for the exact format. On 30 May, 2013, at 2:33 PM, Anssi Seppälä wrote: > 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 me