SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Date function

518343Jun 27 2006 — edited Jun 27 2006

Good Morning:

How would I go about getting the date from the database and format it (mm/dd/yyyy hh12:mi:ss am) but still retain the Date format.
Tried doing to_date(to_char(sysdate, 'mm/dd/yyyy hh12:mi:ss am')) but it gives an error.

I don't want to convert it to a to_char because the receiving Java program has a java.sql.Date format..

Current result : 2006-06-24 17:27:11.0
Needed result 06/24/2006 05:27:11 PM

Thank you for the help. Appreciate this forum as its a great source of information : )

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2006

Added on Jun 27 2006

3 comments

293 views