How to convert string to date in oracle

In Oracle, you can use the to_date() function to convert a string into a date. This function can format the string according to the specified format and convert it into a time type result. The syntax "to_date("The characters to be converted String","conversion format")".

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

In Oracle, you can use the to_date() function to convert a string into a date.

to_date(x[,f])The function can format the stringxaccording to the formatfand convert it into a time type result.

Specific syntax:

to_date("要转换的字符串","转换的格式")

Note: The format of the two parameters must match, otherwise an error will be reported.

Conversion format:

• Represents year: y Represents the last digit of the year yy Represents the last 2 digits of the year yyy Represents the last 3 digits of the year yyyy Use 4 The number of digits represents the year

• represents the month: mm represents the month with 2 digits; mon represents the month in abbreviated form such as November or nov; month represents the full name such as November or November

• means day: dd means the day of the month; ddd means the day of the year; dy is the abbreviation of the day of the week, such as Friday or fri; write the day of the week in full

• For example, Friday or friday.

• means hour: hh 2 digits means hour in hexadecimal; hh24 2 digits means hour 24 hours

• means minute: mi 2 digits represents the minute

• represents the second: ss 2 digits represents the second in hexadecimal

• represents the quarter: q One digit The number represents the quarter (1-4)

• In addition, ww is used to represent the week of the year and w is used to represent the week of the month.

  Time range under 24-hour format: 00:00:00-23:59:59

  Time range under 12-hour format: 1:00:00-12:59:59

Example:

select to_date('2022-01-13','yyyy-mm-dd') from dual;

Output result:

2022/01/13

Recommended tutorial: "Oracle Tutorial"

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