Need a Date format which supports in JAVA as well as Oracle

Question

I need a date format in 24 hours along with minutes, that date format should work in both JAVA as well as Oracle. Can any one please suggest some date format which will helpful for me.

Thanks in advance....

score 1 · Answer 1 · edited May 23 '17 at 11:48

1

I would think the oracle jdbc-driver handles this for you, but if you need more control, the best choice is probably ISO-8601. This can be converted to java as described here:

Converting ISO 8601-compliant String to java.util.Date

And to oracle as described here:

How to convert "1985-02-07T00:00:00.000Z" (ISO8601) to a date value in Oracle?

edited May 23 '17 at 11:48

Community

1
1

answered Feb 07 '13 at 06:22

Rolf Rander

3,221
20
21

score 0 · Answer 2 · answered Feb 07 '13 at 06:18

0

the format would be yyyy-mm-dd where y is for year,m is for month and d is for date

answered Feb 07 '13 at 06:18

please specify hours and minutes also along with date – KrishnaTeja Feb 07 '13 at 06:23

Need a Date format which supports in JAVA as well as Oracle

2 Answers2