Formatting Dates |
||||
The TO_CHAR FunctionYou can use the TO_CHAR function to customize the display of your dates returned from a SQL SELECT statement. The TO_CHAR function has two parameters. The first parameter is the date that you want to convert. The second parameter is the format model, which specifies the way that you want the date to look when displayed. Many format models are available. A few are shown in the table below: The NATURAL JOIN clause and the USING clause are mutually exclusive. They cannot be used in the same SELECT statement. Use the USING clause if your tables contain more than one column whose names match to explicitly identify the name of the columns that you want to join.
|