Thursday, October 12, 2006

Formating date field in LOV in Oracle Designer 2000

I have a problem with formatting data field in list of values in Oracle Designer,even if i put format mask for the date field 'dd-mm-yyyy',it appears at runtime in the following format:
'YY-MM-DD'
To resove this problem i tried to add a string value named NLS_DATE_FORMAT to the oracle designer home under :
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\DESIGNER_HOME]
Create a string value named NLS_DATE_FORMAT and put the format you want to use for your date, DD-MM-YYYY , for example.

N.B: Replace DESIGNER_HOME by yours.
Review your forms and you will see the date field well formatted in the LOV
Happy coding

No comments: