My Work
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
search engine
Custom Search
No comments:
Post a Comment