Wednesday, October 22, 2008

How to Store only time in Oracle

SQL> create table aa(aaa date);

Table created.

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'HH24:MI:SS';

Session altered.

SQL>
SQL> insert into aa values(sysdate);

1 row created.

SQL> select * from aa;

AAA
--------
23:51:36

No comments:

search engine

Custom Search