Guest User

Untitled

a guest
Feb 13th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';
  2.  
  3. Session altered.
  4.  
  5. SQL> create table test
  6. 2 (isbn varchar2(30),
  7. 3 date_entered date default sysdate
  8. 4 );
  9.  
  10. Table created.
  11.  
  12. SQL> insert into test (isbn) values ('1234');
  13.  
  14. 1 row created.
  15.  
  16. SQL> select * From test;
  17.  
  18. ISBN DATE_ENTERED
  19. ------------------------------ -------------------
  20. 1234 13.02.2018 19:45:34
  21.  
  22. SQL>
Add Comment
Please, Sign In to add comment