This combination date and time data type is displayed in the format yyyy-mm-dd-hh.mm.ss.nnnnnn. The following table describes the various components of this field. As an example, the timestamp for 7:45:34pm on June 18, 1992 would be 1992-06-18-19.45.34.000000. When including a timestamp value in an SQL command, enclose it in quotes. Timestamp requires 12 bytes of storage. If the column is specified as NOT NULL WITH DEFAULT, null values will be replaced by the current timestamp.
| Format | Description |
|---|---|
| YYYY | An integer from 0001 to 9999, representing a year. |
| MM | An integer from 1 to 12 representing a month. |
| DD | An integer from 1 to 31 (maximum depends on the month and year) representing the day of the month. |
| hh | An integer from 0 to 24, representing the hour. |
| mm | An integer from 0 to 59, representing minutes. |
| ss | An integer from 0 to 59 representing seconds (default 0). |
| nnnnnn | An integer (up to 6 digits) representing microseconds. If any trailing digit is omitted, 0 is assumed. |