Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on difference between day,fmday and month,fmmonth within the SQL forums, part of the Databases category; a) difference between day and fmday b) difference between month and fmmonth...
|
|||||||
|
|||
|
Re: difference between day,fmday and month,fmmonth
Fill mode. Oracle uses blank characters to fill format elements to a constant width equal to the largest element for the relevant format model in the current session language. For example, when NLS_LANGUAGE is AMERICAN, the largest element for MONTH is SEPTEMBER, so all values of the MONTH format element are padded to 9 display characters. This modifier suppresses blank padding in the return value of the TO_CHAR function:
In a datetime format element of a TO_CHAR function, this modifier suppresses blanks in subsequent character elements (such as MONTH) and suppresses leading zeroes for subsequent number elements (such as MI) in a date format model. Without FM, the result of a character element is always right padded with blanks to a fixed length, and leading zeroes are always returned for a number element. With FM, which suppresses blank padding, the length of the return value may vary. In a number format element of a TO_CHAR function, this modifier suppresses blanks added to the left of the number, so that the result is left-justified in the output buffer. Without FM, the result is always right-justified in the buffer, resulting in blank-padding to the left of the number.
__________________
Sireesha |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| May 07 : Member of the Month | admin | Site News & Announcements | 13 | 06-27-2007 02:56 AM |
| Feburary 07 : Member of the Month | admin | Site News & Announcements | 3 | 03-08-2007 07:47 AM |
| Wedding month | raju1984 | Brainteasers | 5 | 01-18-2007 02:49 AM |
| which day of the month is my birthday ? | psuresh1982 | Brainteasers | 5 | 01-03-2007 03:58 AM |
| Find out the Month and the Day | scott | Brainteasers | 5 | 11-02-2006 02:18 AM |