本文介绍了甲骨文如何输出日期和时间?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的访问表如下:
insert into Visit values(12, to_date('19-JUN-13', 'dd-mon-yy'), to_date('19-JUN-13 12:00 A.M.' , 'dd-mon-yy hh:mi A.M.')); insert into Visit values(15, to_date('20-JUN-13', 'dd-mon-yy'), to_date('20-JUN-13 02:00 A.M.' , 'dd-mon-yy hh:mi A.M.')); insert into Visit values(18, to_date('21-JUN-13', 'dd-mon-yy'), to_date('21-JUN-13 10:30 A.M.' , 'dd-mon-yy hh:mi A.M.'));当我尝试查询它: select * from Visit 我得到:
When i try to query it: select * from Visit i get:
SQL> select * from visit; SLOTNUM DATEVISIT ACTUALARRIVALTIME ---------- --------- ------------------------------ 12 19-JUN-13 19-JUN-13 15 20-JUN-13 20-JUN-13 18 21-JUN-13 21-JUN-13 SQL> spool off;如何到达时间不在?
推荐答案您还可以设置适用于所有日期的格式:
You can also set a format that applies to all dates like this:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH:M:SS PM';这样,您的原始查询将以您之前的格式输出日期,而不使用 TO_CHAR 。要恢复到通常的默认格式,只需执行以下操作:
That way, your original query would output the dates in the format you're after, without using TO_CHAR. To set back to the usual default format, just do this:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RR';更多推荐
甲骨文如何输出日期和时间?
发布评论