Timestamp

From Oracle FAQ

(Redirected from TIMESTAMP)
Jump to: navigation, search

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

[edit]

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
[edit]

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
[edit]

Also see


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 #
Retrieved from "http://www.orafaq.com/wiki/Timestamp"
Personal tools