Notifications
Clear all
Topic starter
Hi. I use SQL Developer a lot, but I can't figure out how to get the ML.DOCCONTB.DB_CREATE_DATE field to show the time. According to the 9.8 data dictionary, this field is supposed to be date/TIME stamp, not just a date stamp. But in all of my reports, all that is ever pulled in is the date. I need to run a report on a particular provider's documents that show the same data that is displayed when viewing the contributor's list on the Documents list. That information shows the times, which is what I need.
I would appreciate any help, and will gladly trade SQL scripts.
Thanks.
Robin
Posted : September 21, 2015 11:34 am
Topic starter
I found my answer in an old script:
TO_CHAR(ML.DOCCONTB.DB_CREATE_DATE, 'YYYYMMDDHHmmSS') AS DATETIME
Thanks anyway.
Robin
Posted : September 21, 2015 4:23 pm
If you would like to fix it in SQL Developer, go to Tools ->Preferences ->Database -> NLS and change the date format.
Posted : September 23, 2015 5:07 am
