How to convert date to string in oracle

In Oracle, you can use the to_char() function to convert dates into strings. The function of this function is to convert numeric or date types into character types; the syntax is "to_char(x[,f]) ", the date type x can be formatted and converted into a string according to format f.

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

In Oracle, you can use the to_char() function to convert dates into strings.

The function of Oracle to_char function is to convert numeric or date type into character type.

Syntax:

to_char(x[,f])

The date type x can be formatted and converted into a string according to format f.

Template for date/time conversion (possible values ​​of f)

##am or a.m. or pm or p.m.Noon designation (lowercase)Y,YYYYear with comma (4 and more digits)YYYYYear (4 and more digits)##YYYYYYBC or B.C. or AD or A.D.##bc or b.c. or ad or a.d.Year identification (lowercase)MONTHFull uppercase month name (9 characters)MonthFull-length mixed-case month name (9 characters)monthFull-length lowercase month name (9 characters)MONAbbreviated month name in upper case (3 characters)MonAbbreviated month name in mixed case (3 characters)monLowercase abbreviated month name (3 characters) MMMonth (01-12) DAYFull uppercase date name (9 characters) DayFull length mixed Uppercase and lowercase date names (9 characters) dayFull-length lowercase date names (9 characters) DYAbbreviated uppercase date name (3 characters)DyAbbreviated mixed-case date name (3 characters)dyAbbreviated lowercase date name (3 characters)DDDDays of the year (001-366)DDDays in a month (01-31)DDays in a week ( 1-7; SUN=1)WThe number of weeks in a monthWeeks in a yearCentury (2 digits) Julian date (date since January 1, 4712 BC) QuarterlyRoman numeral month (I-XII; I=JAN) - capital Roman numeral month (I-XII; I= JAN) - lowercase

Template

Description

HH

The number of hours in a day (01-12)

HH12

The number of hours in a day (01-12)

HH24

Hours in a day (00-23)

MI

Minutes (00- 59)

SS

Seconds (00-59)

SSSS

Seconds after midnight (0-86399)

AM or A.M. or PM or P.M.

Noon mark (uppercase)

Last three digits of year

The last two people of the year

The last two people of the year

Year identification (upper case)

##WW

CC

J

Q

RM

rm

示例：

select to_char(sysdate,'yyyy-mm-dd') from dual;

2018-11-13

to_char 例子 

输入	输出
to_char(now(),'Day, HH12:MI:SS')	'Tuesday , 05:39:18'
to_char(now(),'FMDay, HH12:MI:SS')	'Tuesday, 05:39:18'
to_char(-0.1,'99.99')	' -.10'
to_char(-0.1,'FM9.99')	'-.1'
to_char(0.1,'0.9')	' 0.1'
to_char(12,'9990999.9')	' 0012.0'
to_char(12,'FM9990999.9')	'0012'
to_char(485,'999')	' 485'
to_char(-485,'999')	'-485'
to_char(485,'9 9 9')	' 4 8 5'
to_char(1485,'9,999')	' 1,485'
to_char(1485,'9G999')	' 1 485'
to_char(148.5,'999.999')	' 148.500'
to_char(148.5,'999D999')	' 148,500'
to_char(3148.5,'9G999D999')	' 3 148,500'
to_char(-485,'999S')	'485-'
to_char(-485,'999MI')	'485-'
to_char(485,'999MI')	'485'
to_char(485,'PL999')	'+485'
to_char(485,'SG999')	'+485'
to_char(-485,'SG999')	'-485'
to_char(-485,'9SG99')	'4-85'
to_char(-485,'999PR')	''
to_char(485,'L999')	'DM 485
to_char(485,'RN')	' CDLXXXV'
to_char(485,'FMRN')	'CDLXXXV'
to_char(5.2,'FMRN')	V
to_char(482,'999th')	' 482nd'
to_char(485, '"Good number:"999')	'Good number: 485'
to_char(485.8,'"Pre-decimal:"999" Post-decimal:" .999')	'Pre-decimal: 485 Post-decimal: .800'
to_char(12,'99V999')	' 12000'
to_char(12.4,'99V999')	' 12400'
to_char(12.45, '99V9')	' 125'

推荐教程：《Oracle教程》

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