Forum Stats

  • 3,826,359 Users
  • 2,260,635 Discussions
  • 7,896,916 Comments

Discussions

Display VO timestamp attribute in the format of 'MM/DD/YYYY HH24:MI:SS'

2954073
2954073 Member Posts: 8
edited Jun 15, 2020 1:49PM in JDeveloper and ADF

Hello All,

I have a VO with attribute type Timestamp , I tried to display it in the format of ('MM/DD/YYYY HH24:MI:SS') but with no luck still.

The available formats in Jdeveloper do not have the above format.

Am I supposed to use groovy? if yes what to do?

If not how can I achieve this format?

Thank you

Amal

Tagged:

Answers

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,457 Red Diamond
    edited Jun 9, 2020 9:10AM

    User, tell us your exact JDev version, please!

    In the EO or VO you select the attribute, then select the U-Hint tab and set 'Simple Date' as format type, then you can enter your pattern as 'yyyy/MM/dd hh:mm:ss' into the format field:

    pastedImage_0.png

    In the UI you get

    pastedImage_1.png

    Timo

  • Dimitar Dimitrov
    Dimitar Dimitrov Member Posts: 921 Bronze Trophy
    edited Jun 15, 2020 1:49PM

    Just a small correction - he asked for HH24:MI:SS, so 'hh' in the Java format mask must me either 'HH' (for hour in day 00-23) or 'kk' (for hour in day 01-24). Also he asked for MM/DD/YYYY, so Java format mask must be 'MM/dd/yyyy':

    MM/dd/yyyy HH:mm:ss

    MM/dd/yyyy kk:mm:ss