format mask [message #1116] |
Tue, 02 April 2002 17:44 |
fidelia
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
I'd like to know what is format mask and when/how to use it.
thanx a lot
|
|
|
Re: format mask [message #1121 is a reply to message #1116] |
Tue, 02 April 2002 21:21 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
Hello,
a format mask is nothing more than a certain format you give to an output. For example : a date in your database is kept in a date variable in the next form :
15-jan-02. In case you want to put it in another form (let's say like 15-01-2002), then you have to give the date a new format : to_char(date,'DD-MM-YYYY'). This is a format mask : you give the date a new face, a new mask but only on format level, the contents or meaning remains the same.
Success,
epe
|
|
|
Re: format mask [message #1602 is a reply to message #1121] |
Wed, 15 May 2002 10:33 |
Nadeem Zia
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
I have a problem with FM. When I was using it on sql/plus , it didnt give me the result.
I need to display telephone number whihc I mentioned in variable like 9372366666, & I need to display it like: (937) 236-6666.
With the help of FM"("999")" 999"-"9999.
Please help me out.
Thanx
|
|
|