Print Thread
Grid Date / Time Formats
#64244 09/23/22 01:29 PM
Joined: Sep 2022
Posts: 3
S
Member
OP Offline
Member
S
Joined: Sep 2022
Posts: 3
I've upgraded to V15 and want to retain formats of dates & times from previous version.
I've added
NLS_DATE_FORMAT=dd-Mon-yyyy
NLS_TIME_FORMAT=HH24:MI:SS
to the params.ini file
and amended the NLS Options in Preferences to match these as "user defined"
but - grid date/time is gobbledegook, for example, "23-9o19-2022 1124:19I:47"
I've tried all apparent combinations to no avail - what am I doing wrong?

Re: Grid Date / Time Formats
Stephen Young #64245 09/24/22 02:59 PM
Joined: Sep 2022
Posts: 3
S
Member
OP Offline
Member
S
Joined: Sep 2022
Posts: 3
Solved!
In the Preferences for User Defined dates & times you need to use Windows formats (not Oracle).
So date is dd-MMM-yyyy and time is HH:mm:ss


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.147s Queries: 15 (0.085s) Memory: 2.4946 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-04-18 11:37:24 UTC
Valid HTML 5 and Valid CSS