Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

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!

JPQL select date in a special format?

ericmacau-830049Mar 24 2011 — edited Mar 24 2011
Hello,

How can I use JPQL to select a date as a string with a specific format?

In PL/SQL, I can "select to_char(THE_DATE, 'yyyy-MM-dd') as theDate from USER";

How can I do this in JPQL?

Best regards,
Eric
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2011
Added on Mar 24 2011
1 comment
1,495 views