Hello everyone.
Good Day.
I would like to seek your help regarding my inquiry on the PL/SQL script output that I am trying to create.
Please see below output of my script:
L7,CU4450278,70X1W01AGA-ASY,11813,20-6æ -13,0
L7,CU4464442,747X32VH9015-ASY,3394,20-6æ -13,0
L7,CU4464766,747X22VH9015-ASY,3383,21-6æ -13,0
As you can see in the CSV output, the date has some invalid value, the "6æ " should have been Jun (i.e. Short Month format of June).
My script has this code for date dbms_output to_char(startplan_rec.str_startdate,'DD-MON-YY')
The startplan_rec.str_startdate data type is date.
I have tried querying the same table in the oracle sql developer, but i am getting the correct output (e.g. 20-Jun-13).
Please help me on having my desired date format output on my pl/sql. Why is my date output on my script incorrect?
Thanks in advance.
Regards,
Jeff.