Hi,
Can anyone please help me to display date field in the format DDMMYYYY which I need single digit date needs to have leading 0 like 01022000.
I tried to-char but leading 0 is not there.
I am writing object script with the help of sql query for generating extracts.
can anyone please help on this.
thanks
jude