How to query the month in oracle

In Oracle, you can use the "to_char()" function and the "mm" keyword to query the month. The "to_char()" function is a string conversion function, and the syntax is "where to_number(to_char(table Date field,'mm'))=the month to be found".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to query the month in oracle

to_char() is Oracle’s character conversion function. to_char(value,'format') value is the value to be converted, and 'format' is the converted pattern.

The style fm9900.0099 here includes the following meanings:

The output string occupies a total of 9 digits, 4 digits before the decimal point and 4 digits after the decimal point.

9 represents the meaning. If the position is a number, the number will be displayed. Otherwise, a space will be used to replace the placeholder. In short, this position must be occupied.

0 represents the meaning. If the position is a number, the number will be displayed. Otherwise, 0 will be used instead of the placeholder. In short, this position must be occupied.

The syntax is:

SELECT * FROM [表名] 
      where  to_number(to_char([表中日期字段],'mm')) = [要查找的月份]

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to query the month in oracle. For more information, please follow other related articles on the PHP Chinese website!