string to oracle date in java

Question

I have a string in the format "dd.mm.yyyy hh:mm".. i need to convert it into oracle date format 'dd-mon-yy'..... How do i make it happen???

D0cNet · Accepted Answer · 2010-09-30 05:28:51Z

1

How is the string sent to oracle?? Use the to_date() function to convert the java string to oracle date. http://www.techonthenet.com/oracle/functions/to_date.php

answered Sep 30, 2010 at 5:28

D0cNet

3144 silver badges20 bronze badges

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

2 Comments

apoorvabade Over a year ago

Actually i wish to send the string to a web service which in turn access the database. So i wanted to convert it to the oracle date in java.

D0cNet Over a year ago

Yeah well you can always pass it as string formatted however, then in oracle just use the to_date(<string>,<same format>) and convert it using the same format.

OMG Ponies · Accepted Answer · 2010-09-30 15:33:40Z

1

It's not clear where the string is, considering the java tag... Assuming a column value:

SELECT TO_CHAR(TO_DATE(t.column, 'DD.MM.YYYY HH24:MI'), 'DD-MON-YYYY')
  FROM YOUR_TABLE t

edited Sep 30, 2010 at 15:33

answered Sep 30, 2010 at 4:59

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Comments

Shekhar · Accepted Answer · 2010-09-30 04:58:40Z

0

You can use to_char() method of oracle. You can get more information about date conversion here.

answered Sep 30, 2010 at 4:58

Shekhar

11.9k38 gold badges135 silver badges191 bronze badges

Comments

Sean · Accepted Answer · 2010-09-30 05:25:47Z

0

If you want to perform an sql query against your database via prepared statment you can use

java.sql.Date

which stores the Date. Note that this object does not store time, just month, day and year. Also see

java.sql.Time
java.sql.Timestamp

If you are looking to format the date for display purpose, try

java.text.DateFormat

answered Sep 30, 2010 at 5:25

Sean

7,7371 gold badge26 silver badges27 bronze badges

1 Comment

apoorvabade Over a year ago

I wish to select particular records based on some date. This date is coming in the form of String from the GUI. So i need to convert to string into oracle date.

Collectives™ on Stack Overflow

string to oracle date in java

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related