fm signifies that you dont want the leading characters. From the docs: Fill mode. Oracle uses trailing blank characters and leading zeroes to fill format elements to a constant width. The width is equal to the display width of the largest element for the relevant format model
The FM modifier suppresses the above padding in the return value of the TO_CHAR function.
2条答案
按热度按时间xlpyo6sf1#
fm signifies that you dont want the leading characters.
From the docs:
Fill mode. Oracle uses trailing blank characters and leading zeroes to fill format elements to a constant width. The width is equal to the display width of the largest element for the relevant format model
The FM modifier suppresses the above padding in the return value of the TO_CHAR function.
wixjitnu2#
fm（填充模式）运算符删除TO_CHAR函数中日期的月、日中的多余空格。