Skip to Main Content

Java Development Tools

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!

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

2954073Jun 9 2020 — edited Jun 15 2020

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

Comments

use preferred abbreviation - here are two pictures
Attribute_pref_abbreviation.png
engineering_pref_abbrev.png
Philip

Mike Kutz

@philip-stoyanov-oracle
The PK Attribute on the Parent Entity comes from "Create Surrogate key" on the parent Entity (image 1)
The Attribute I want to modify isn't listed on the Child Entity (image 2).
Beyond that, it looks like this trick should work.
MK
Image 1 - PK on Parent is auto-created
image.png
Image 2 - no Attribute to modify.
image.png

is there a rule for that name?
Philip

Mike Kutz

Where to check?
I'm just starting to use SDDM. I don't think I defined any naming rules.
I've modified the Naming Templates (image). But that should be it. maybe a few check boxes for Engineering.
MK
image.png

HansJK

You can also just type the name you want while editing that attribute in the attribute list.
It will get overridden if you should re-run naming conventions. So I paste my chosen name into the comments of that attribute (not RDBMS comments, just tool comments). then at least I can copy paste it back or I make sure to re-run naming conventions opton without foreign key columns applied.

well, if you want the name to not change then you can use "Tools>Object names administration" utility to make that name unchangeable

Philip

HansJK

Thank you @Philip Stoyanov-Oracle. That is cool.
If I may, it would have been nice if a direct "link" to that feature would be that I could on the relevant object/attribute indicate/tick that it must be fixed and not have to go to another screen to achieve this. Also having this "central" place/way of being able to see all things flagged as fixed.
Just my two cents...

1 - 7

Post Details

Added on Jun 9 2020
2 comments
820 views