Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Informix
Expertise: Beginner
Jul 17, 2000

Date Time Values in Parameterized Queries

Question:
I have a parameterized SQL statement like the following:
"insert into eSession (ESessionID, eUserName, eLastActivityTime) 
VALUES(?,?,?)"
It's parameters are 'bbb','name' and '2000/01/01 22:23:25', using an ODBC connection. I can't make the date work. Even using the ODBC timestamp format of {ts'yyyy-dd-mm hh:nn:ss'} does no good, although it does work when the statement is not parameterized, like so:
"insert into eSession (ESessionID, eUserName, eLastActivityTime) 
VALUES('bbb','name',{ts '2000-01-01 22:23:25'})"
Is there a generic solution that works with SQL Server, Oracle and Access (I know, but I was young and needed the money)?

Answer:
Is eSession(eLastActivityTime) a time or a datetime format? Try putting double quotes around the date-time and see what that does.

Otherwise, since you can run it in a non-parameterized statement, the problem must lie in the parameterization process.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap