How to insert custom date time in oracle using java?

Question

Hi i have a column (type date).I want to insert custom date and time without using Preparedstatement .i have used

String date = sf.format(Calendar.getInstance().getTime());
String query = "Insert into entryTbl(name, joinedDate, ..etc)  values ("abc", to_date(date, 'yyyy/mm/dd HH:mm:ss'))";
statement.executeUpdate(query);

but am getting literal doesnot match error. so even tried with "SYSDATE".Its inserting only date not time.So how to insert the datetime using java into oracle?please any one help..

any specific reason to not use PreparedStatement?

Vikdor
– Vikdor

2012-10-26 04:40:48 +00:00
Commented Oct 26, 2012 at 4:40 — Vikdor
– Vikdor, Commented Oct 26, 2012 at 4:40

Vikdor · Accepted Answer · 2012-10-26 04:44:29Z

1

It is strongly recommended to use PreparedStatement to counter potential SQL injection attacks, instead of building raw SQL queries to interact with the database.

That said, you can specify the value for date column as a string in yyyy-MM-dd HH:mm:ss format as well:

SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String date = sf.format(Calendar.getInstance().getTime());
String query = "INSERT INTO entryTbl(name, joinedDate, ..etc.,)  values ('abc', '" 
    + date + "', ...etc.,)";
statement.executeUpdate(query);

answered Oct 26, 2012 at 4:44

Vikdor

24.2k10 gold badges66 silver badges86 bronze badges

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

1 Comment

shree Over a year ago

Because of lot columns in my table.We do not know lot of fields whether we put setInt() ,setString() and where fields also by using PreparedStatement.So we have used directly query to execute tat command...and above query also not able to inserting wat u mentioned...isthere any other way?

Yogendra Singh · Accepted Answer · 2012-10-26 04:51:44Z

0

I think yyyy/mm/dd HH:mm:ss should be updated as : YYYY/MM/DD HH:MI:SS TZH:TZM and use to_timestamp--documentation here

 String query = "INSERT INTO entryTbl(name, joinedDate, ..etc.,) "+
           "values ('abc', "+
           "TO_TIMESTAMP('"+dateString+"', 'YYYY/MM/DD HH:MI:SS TZH:TZM'), etc.,)";

edited Oct 26, 2012 at 4:51

answered Oct 26, 2012 at 4:45

Yogendra Singh

34.5k7 gold badges66 silver badges73 bronze badges

1 Comment

Yogendra Singh Over a year ago

@shrr: Please share the dataString? Also share the new error after using the above syntax.

Collectives™ on Stack Overflow

How to insert custom date time in oracle using java?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related