How to convert date to string in oracle-Oracle-php.cn

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.

How to convert date to string in oracle

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])

Copy after login

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

Year identification (upper case)

##WW

示例：

select to_char(sysdate,&#39;yyyy-mm-dd&#39;) from dual;

2018-11-13

Copy after login

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')	`'<485>'`
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!

Related labels：

oracle

source：php.cn

Previous article：How to modify fields in oracle database Next article：How to close an instance in oracle

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn