SQL> alter session set nls_date_format='yyyymmdd hh24:mi:ss';
Session altered.
SQL> select to_date('20101010 00:00:00','yyyymmdd hh24:mi:ss')+1/86400 from dual;
TO_DATE('20101010
-----------------
20101010 00:00:01
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21993926/viewspace-678031/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- PARALLEL_EXECUTION_MESSAGE_SIZE
- some suggestions for rac performance
- ORA-01931: cannot grant UNLIMITED TABLESPACE to a role on 10g
- RMAN-06094 Datafile does not exist
- MRP0: Background Media Recovery terminated with error 1274
- set up a standby quickly by duplicate.
- how to mount diskgroup automatically
- alias doesn't work on solaris
- ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1]
- rac installation on Solaris10 x86-64
