How to embeded Datetime into SQL String

Question

I have a need to use Statement.executeUpdate() to insert data into Database. So every parameter must be embeded into a SQL string. In Database, the type of two columns are datetime: Date1 and Date2 At client side, if I use following statement:

String SQLString = "INSERT INTO Position (" +
    ......
    "Date1, " +
    ......
    "Date2) " +
    "VALUES(" +
    ......
    //"2012-05-29 16:28:58.555" + ", " + // runtime error, always say error at 16
    //"2012-05-29" + ", " + // no runtime error, but lost time and result date is also not correct
    //"10-06-02" + ", " + // no runtime error, but it adds 2 days beginning at 1900-01-01 00:00:00.000
    ......
    null
    ")";

Can anyone tell me how to correctly embedded Datetime into SQL String?

similar to: stackoverflow.com/questions/3226390/…

ControlAltDel
– ControlAltDel

2012-05-29 15:19:14 +00:00
Commented May 29, 2012 at 15:19 — ControlAltDel
– ControlAltDel, Commented May 29, 2012 at 15:19

aleroot · Accepted Answer · 2012-05-29 15:18:54Z

4

You should use a PreparedStatement and pass the date field ad Date ...

String SQLString = "INSERT INTO Position (Date1) VALUES (?)";
PreparedStatement prest = con.prepareStatement(SQLString);
prest.setDate(1,new Date());
prest.executeUpdate()

answered May 29, 2012 at 15:18

aleroot

73k32 gold badges182 silver badges220 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

newman Over a year ago

Thank you for your reply. But I HAVE TO use Statement.executeUpdate(), so Can anyone tell me how to correctly embedded Datetime into SQL String?

aleroot Over a year ago

What is the SQL version ? Should work with : YYYY-MM-dd HH:mm:ss or without the time simply with : YYYY-MM-dd or YYYYMMdd

adarshr · Accepted Answer · 2012-05-29 15:18:55Z

2

First up, you have to use PreparedStatement. Then you could do something like:

statement.setDate(2, new Date());

answered May 29, 2012 at 15:18

adarshr

62.8k24 gold badges146 silver badges175 bronze badges

1 Comment

newman Over a year ago

Thank you for your reply. But I HAVE TO use Statement.executeUpdate(), so Can anyone tell me how to correctly embedded Datetime into SQL String?

Collectives™ on Stack Overflow

How to embeded Datetime into SQL String

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related