Call a function from a field in Java PreparedStatement?

Question

Having a PreparedStament, I have a field of type timestamp and I don't want to set it to a fixed value but call NOW() instead. How do I do that?

I tried:

statement.setString(11, "NOW()")

but that tries to set the field to the string "NOW()" instead of calling NOW().

Thanks.

https://stackoverflow.com/questions/7626076/how-to-set-current-date-and-time-using-prepared-statement — Reimeus, Jul 17 '17 at 10:57

score 3 · Answer 1 · answered Jul 17 '17 at 10:55

3

You cannot do that. But in the SQL of the prepared statement, instead of using ?, you can use NOW().

Alternatively, you can keep the ? in the SQL, and do statement.setDate( 11, new Date() );

answered Jul 17 '17 at 10:55

Mike Nakis

56,297
11
110
142

Austin Schaefer · Answer 2 · 2017-07-17T11:58:38.853

1

Call preparedStatement.setTimeStamp(11, LocalDateTime.now().toString())

If you aren't using Java 8, or want to learn how to get the current time as a String, see this.

edited Jul 17 '17 at 11:58

answered Jul 17 '17 at 11:52

Austin Schaefer

695
5
19

score 0 · Answer 3 · answered Jul 17 '17 at 11:16

It seems you are willing to call mysql now() function that returns the current date-time stamp.

If so, then you must put now() in queryString as "String part of the query", if you try to put it using preparedStatement then it will be treated as pure string value not as mysql function.... see this http://www.mysqltutorial.org/mysql-now/

OR

If you want to call a java code function named now() then remove the double quotes from it and make sure it returns String.

Call a function from a field in Java PreparedStatement?

3 Answers3