date format in oracle 1

[jhoann]

Hi,

I have a database field called due_date, the data type is date and the format is DD-MON-YY so the output is like this 06-JAN-03 , It means January 6, 2003

I want to format my date like this ...6 January,2003,
i want to remove the zero beside the 6.

can it be done in oracle.. using format mask... I can't do it... is there some other way ?

Thanks,
Jhoann

 

[sem]

'fmDD Month, yyyy'

Regards, Dima

 

[jhoann]

thanks for you time

it's data type is Char right?

how about I want my data type is DATE ?

thanks again,
Jhoann

 

[jhoann]

I got it already....thanks a lot


Jhoann

 

[jhoann]

Hi,

It's me again....

'fmDD Month, yyyy' - tried this one and it works :
my output is like this ...
01-JAN-03 = it became 1 January, 2003

how about the format like this ...
1 Jan, 2003 , can it be done... what format mask will I use to format the date (data type : date) to like this ...
1 Jan, 2003


Thanks,
Jhoann

 

[munee]

'FMDD MON, YYYY'

But it will show 01 JAN, 2000
I do not know how to just show 1 JAN,2000.