PreparedStatement and CURDATE() MySQL function

Question

What is the correct way to use CURDATE() mysql function in PreparedStatements? Table column is DATE type and inserted value in table must be like 1988-07-29.

ps.setDate(5, ...);

(http://stackoverflow.com/a/7626080/2749470) this may help you out — Bhargav Modi, Dec 19 '14 at 10:05
Why not make the `curdate()` call part of your SQL statement and remove the parameter for it? — , Dec 19 '14 at 10:10
@BhargavModi should accept your answer as accepted, it works — andy007, Dec 19 '14 at 10:25
@BhargavModi I think Yes, because the answer is just use now() in SQL statement and remove the parameter for it. — andy007, Dec 19 '14 at 10:29

score 2 · Answer 1 · answered Dec 19 '14 at 10:01

2

There is none. You either create current date in Java or prepare the statement with CURDATE()

answered Dec 19 '14 at 10:01

Mchl

61,444
9
118
120

Manoj Sharma · Answer 2 · 2014-12-19T10:07:27.133

2

Do Like:

SimpleDateFormat f = new SimpleDateFormat("yyyy-MM-dd");
String fd = f.format(new Date());
Date date = f.parse(fd);
preparedStatement.setTimestamp(index, new Timestamp(date.getTime()));

edited Dec 19 '14 at 10:07

answered Dec 19 '14 at 10:02

Manoj Sharma

596
1
6
23

score 1 · Answer 3 · answered Dec 19 '14 at 10:04

1

Do Like

preparedStatement.setTimestamp(5, new Timestamp(new Date().getTime()));

answered Dec 19 '14 at 10:04

Siva Kumar

1,983
3
14
26

score 1 · Accepted Answer · answered Dec 19 '14 at 10:38

You can do it in two ways one is from java as below Using java.sql.Date

e.g.: Using java.sql.Date:

java.sql.Date date = java.sql.Date.valueOf("2013-09-04");

If you want to insert the current date:

ps.setDate(2, new java.sql.Date(System.currentTimeMillis()));

Using java.sql.Timestamp:

ps.setTimestamp(2, new java.sql.Timestamp(System.currentTimeMillis()));

Another way is from SQL through database support operations like now() for MySQL or current_timestamp() for PostgreSQL etc just have a look on below example

String sql = "INSERT INTO user (email, creationdate) VALUES (?, now())";//for MySQL

for more details Use this link(one of my favourite author).

Happy to Help you :)

PreparedStatement and CURDATE() MySQL function

4 Answers4