devxlogo

Date Time Values in Parameterized Queries

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.

See also  5 Ways to Improve Customer Experience
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist