oracle查询基础1.ppt

[Title of the course] * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. * SQL provides three functions to convert a value from one data type to another: Function Purpose TO_CHAR(number|date,[ fmt], [nlsparams]) Converts a number or date value to a VARCHAR2 character string with format model fmt Number conversion: The nlsparams parameter specifies the following characters,which are returned by number format elements: ? Decimal character ? Group separator ? Local currency symbol ? International currency symbol If nlsparams or any other parameter is omitted, this function uses the default parameter values for the session. TO_CHAR(number|date,[ fmt], [nlsparams]) Date conversion: The nlsparams parameter specifies the language in which month and day names and abbreviations are returned. If this parameter is omitted, this function uses the default date languages for the session. TO_NUMBER(char,[fmt], [nlsparams]) Converts a character string containing digits to a number in the format specified by the optional format model fmt. The nlsparams parameter has the same purpose in this function as in the TO_CHAR function for number conversion. TO_DATE(char,[fmt],[nlsparams]) Converts a character string representing a date to a date value according to the fmt that is specified. If fmt is omitted, the format is DD-MON-YY. The nlsparams parameter has the same purpose in this function as in the TO_CHAR function for date conversion. Note: The list of functions mentioned in this lesson includes only some of the available conversion functions. [Title of the course] * Copyright ? 2004-2005 NameOfTheOrganization. All rights reserved. * Previously, all Oracle date values were displayed in the DD-MON-YY format. You can use the TO_CHAR function to convert a date from this default format to one that you specify. Guidelines ? The format model must be enclosed by single quotation marks and is case-sensitive. ? The format model can include any valid d