How to insert Current time in TIMESTAMP column(Oracle) from java class using jdbc

Question

i have tryed many things but not able to insert data in my timestamp column. from toad its possible using this

UPDATE SUPPORTSTAFF 
     SET SUPPSTAFFJOINDATE=to_timestamp('27/02/2002 15:51.12.539880', 'dd/mm/yyyy hh24:mi.ss.ff') 
 where JDBCUSERID='5700';

its working

but how can i insert data from java class using create statment and execute query its giving me invalid month error

its done THanks a lot for fast responce .follwed jon's answer .now its working. — rish1690
– rish1690, Commented May 1, 2013 at 14:13

Steve McLeod · Accepted Answer · 2016-07-12 10:24:10Z

23

Use a PreparedStatement with a parameter for the timestamp, e.g.

UPDATE SUPPORTSTAFF SET SUPPSTAFFJOINDATE = ? where JDBCUSERID = ?

and then set the parameters:

statement.setTimestamp(1, new Timestamp(System.currentTimeMillis()));
statement.setString(2, "your ID");

(Then execute the statement, obviously.)

edited Jul 12, 2016 at 10:24

Steve McLeod

52.6k49 gold badges131 silver badges187 bronze badges

answered May 1, 2013 at 13:55

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

7 Comments

rish1690 Over a year ago

Thanks a lot Jon ..you saved my day. was trying from last 4 hour. this was my first question to stackoverflow which was answered in 1 min .awesome.. Just love it

Gaël Oberson Over a year ago

Jon, what about Oracle DB ? I tried this on my oracle 11g and I get an ORA-01461: can bind a LONG value only for insert into a LONG column.

Jon Skeet Over a year ago

@GaëlOberson: That comment doesn't really give enough information - it's not clear where LONG comes into it at all. It sounds like it's worth asking a new question.

Gaël Oberson Over a year ago

@Jon Not really. I have a TIMESTAMP COLUMN in my table, I use a preparded statement and set the column value like in your example, getting the oracle exception i mention.

Jon Skeet Over a year ago

@Telebh: I suggest you ask a new question with a minimal reproducible example. That isn't enough information on its own.

|

Collectives™ on Stack Overflow

How to insert Current time in TIMESTAMP column(Oracle) from java class using jdbc

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related