ExaGridDba

1700 was / was not a leap year

Jul 26th, 2015
404
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. Oracle Linux: 1700 was a leap year
  2. $ cal 2 1700
  3. February 1700
  4. Su Mo Tu We Th Fr Sa
  5. 1 2 3
  6. 4 5 6 7 8 9 10
  7. 11 12 13 14 15 16 17
  8. 18 19 20 21 22 23 24
  9. 25 26 27 28 29
  10.  
  11. Oracle Database: 1700 was not a leap year
  12.  
  13. SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 27 02:43:47 2015
  14.  
  15. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  16.  
  17.  
  18. Connected to:
  19. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  20. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  21. and Real Application Testing options
  22.  
  23. SQL> select to_date('17000301','yyyymmdd') - 1 from dual;
  24.  
  25. TO_DATE('17000
  26. --------------
  27. 17000228 00:00
Advertisement
Add Comment
Please, Sign In to add comment