how to get timestamp from oracle DB using jdbc

Question

how to get timestamp from oracle DB using JDBC? on sql i can use select sysdate from dual.

i was trying something like

ResultSet rs = <>.createPreparedStatement("select sysdate from dual");
rs.executeQuery();

while(rs.next())
  rs.get<What to write here?>

Did you check ResultSet javadoc? docs.oracle.com/javase/6/docs/api/java/sql/… — kosa
– kosa, Commented Jan 27, 2016 at 2:56
did you check this ? stackoverflow.com/questions/21162753/… — prasad
– prasad, Commented Jan 27, 2016 at 2:59

kosa · Accepted Answer · 2016-01-27 02:57:02Z

2

rs.get(1) will solve the problem. otherwise give the alias name to the column and use that.

edited Jan 27, 2016 at 2:57

kosa

66.7k15 gold badges134 silver badges170 bronze badges

answered Jan 27, 2016 at 2:56

BValluri

9661 gold badge6 silver badges10 bronze badges

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

Comments

Faraz · Accepted Answer · 2016-01-27 02:58:08Z

1

SELECT SYSTIMESTAMP FROM DUAL;

SYSTIMESTAMP returns the system date, including fractional seconds and time zone, of the system on which the database resides. The return type is TIMESTAMP WITH TIME ZONE.

edited Jan 27, 2016 at 2:58

answered Jan 27, 2016 at 2:56

Faraz

6,3156 gold badges44 silver badges99 bronze badges

1 Comment

kosa Over a year ago

What it does? try to explain.

Abdelhak · Accepted Answer · 2016-01-27 03:04:22Z

-1

If the value of sysdate is an int you can use this:

  while(rs.next()){
   int sysdate= rs.getInt("sysdate");

But if the value of sysdate is a String you can use this:

   while(rs.next()){
   String sysdate= rs.getString("sysdate");

For more info go to link

edited Jan 27, 2016 at 3:04

answered Jan 27, 2016 at 2:59

Abdelhak

8,4154 gold badges25 silver badges37 bronze badges

Collectives™ on Stack Overflow

how to get timestamp from oracle DB using jdbc

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related