Timestamp

From Oracle FAQ

Timestamp is an extension of the Date datatype that can store date and time data (including fractional seconds).

Example

SQL> CREATE TABLE t1(c1 TIMESTAMP);
Table created.
 
SQL> INSERT INTO t1 VALUES (SYSTIMESTAMP);
1 row created.

SQL> SELECT * FROM t1;
C1
---------------------------
10-DEC-07 10.32.47.797201 AM

SQL> SELECT TO_CHAR(c1, 'DD/MON/YYYY HH24:MI:SS') FROM t1;
TO_CHAR(C1,'DD/MON/Y
--------------------
10/DEC/2007 10:32:47

Internal storage

The timestamp type takes 11 bytes of storage:

SQL> SELECT dump(c1) FROM t1;
DUMP(C1)
----------------------------------------------------
Typ=180 Len=11: 120,107,12,19,23,32,48,21,164,131,24

Also see

• Date

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#