Difference between revisions of "Hijri Date Adjustment in Oracle"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
Perform the following steps to adjust the Hijri date: | Perform the following steps to adjust the Hijri date: | ||
| − | *1. Copy the "[https://drive.google.com/open?id=1mug-_sC-mgaSPYmGsSgsA-4J8pboaeMr lxecal.nlt]" file into Oracle_home\nls | + | *1. Copy the "[https://drive.google.com/open?id=1mug-_sC-mgaSPYmGsSgsA-4J8pboaeMr lxecal.nlt]" file into Oracle_home\nls (you can adjust the file as per your need) |
*2. Shutdown the database (SQL>shutdown immediate) | *2. Shutdown the database (SQL>shutdown immediate) | ||
*3. execute the lxgen.exe command from "Oracle_home\bin" | *3. execute the lxgen.exe command from "Oracle_home\bin" | ||
*4. Start the database | *4. Start the database | ||
| + | |||
| + | Notes: * Gregorian date specified in the deviation should correspond to one of 29th, 30th or 31th days of the Hijri calendar. | ||
| + | * Numbers greater than 10 are used to subtract days, e.g: 11 --> subtract one day, 12 --> subtract two days and etc. | ||
Revision as of 17:54, 28 August 2018
Perform the following steps to adjust the Hijri date:
- 1. Copy the "lxecal.nlt" file into Oracle_home\nls (you can adjust the file as per your need)
- 2. Shutdown the database (SQL>shutdown immediate)
- 3. execute the lxgen.exe command from "Oracle_home\bin"
- 4. Start the database
Notes: * Gregorian date specified in the deviation should correspond to one of 29th, 30th or 31th days of the Hijri calendar.
- Numbers greater than 10 are used to subtract days, e.g: 11 --> subtract one day, 12 --> subtract two days and etc.
