没有这个函数,这个函数是MS SQL select to_char('abc') from dual;
CONVERT SYNTAX: CONVERT(char, dest_char_set [,source_char_set] ) PURPOSE: Converts a character string from one character set to another. The char argument is the value to be converted. The dest_char_set argument is the name of the character set to which char is converted. The source_char_set argument is the name of the character set in which char is stored in the database. The default value is the database character set. Both the destination and source character set arguments can be either literals or columns containing the name of the character set. For complete correspondence in character conversion, it is essential that the destination character set contains a representation of all the characters defined in the source character set. Where a character does not exist in the destination character set, a replacement character appears. Replacement characters can be defined as part of a character set definition. Common character sets include: US7ASCII US 7-bit ASCII character set WE8DEC DEC West European 8-bit character set WE8HP HP West European Laserjet 8-bit character set F7DEC DEC French 7-bit character set WE8EBCDIC500 IBM West European EBCDIC Code Page 500 WE8PC850 IBM PC Code Page 850 WE8ISO8859P1 ISO 8859-1 West European 8-bit character set EXAMPLE: SELECT CONVERT('Grob','WE8HP','WE8DEC') "Conversion" FROM DUAL Conversion ---------- Grob
select to_char('abc') from dual;
char is converted. The source_char_set argument is the name of the character set in
which char is stored in the database. The default value is the database character set. Both the destination and source character set arguments can be
either literals or columns containing the name of the character set. For complete correspondence in character conversion, it is essential
that the destination character set contains a representation of all
the characters defined in the source character set. Where a
character does not exist in the destination character set, a replacement character appears. Replacement characters can be
defined as part of a character set definition. Common character sets include: US7ASCII
US 7-bit ASCII character set
WE8DEC
DEC West European 8-bit character set
WE8HP
HP West European Laserjet 8-bit character set
F7DEC
DEC French 7-bit character set
WE8EBCDIC500
IBM West European EBCDIC Code Page 500 WE8PC850
IBM PC Code Page 850
WE8ISO8859P1
ISO 8859-1 West European 8-bit character set EXAMPLE: SELECT CONVERT('Grob','WE8HP','WE8DEC') "Conversion"
FROM DUAL Conversion
----------
Grob
比如SELECT CONVERT('数据库','UTF8') from dual
和你想要的类型转换搭不上边
oracle: to_char(sysdate,'yyyy/mm/dd')