date format in oracle 1

[jhoann]

i have a problem in formatting my Date

I have a field : Due Date
(Data type : Date ,
Format : DD Month, YYYY )

but why my output is like this : 12 March ,2000 ?
why there is a space after the month (March)???

how to remove the spaces ... thanks a lot

jhoann

 

[BJCooperIT]

Try this:
[tt]
to_char(DUE_DATE,'DD fmMonth, YYYY')
[/tt]
The "fm" suppresses the padding of blanks.

Good Luck!


(select * from life where brain is not null)
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000

 

[jhoann]

thanks a lot BJCooper.

it works

jhoann