CODEWITHSUNDEEP
javasqloracle-database
apoorvabade
apoorvabade

Reputation: 575

string to oracle date in java

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???

Upvotes: 1

Views: 8053

Answers (4)

OMG Ponies
OMG Ponies

Reputation: 332521

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

Upvotes: 1

D0cNet
D0cNet

Reputation: 314

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

Upvotes: 1

Sean
Sean

Reputation: 7737

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

Upvotes: 0

Shekhar
Shekhar

Reputation: 11788

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

Upvotes: 0

Related Questions