Date Functions - 1 |
||||
CharacteristicsOracle XE stores dates in an internal format representing the century, year, month, day, hours, minutes, and seconds. For example, if today is October 6th, 2005, at 07:10 in the morning, the current date is stored internally as October 6, 2005, 07:10:06. The default display and input format for any date in XE is DD-MON-YY. DD stands for the day of the month, MON stands for the first three letters of the month name, and YY stands for the year (which also includes the century). Valid Oracle dates are between January 1, 4712 B.C., and December 31, 9999 A.D. 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.
|