ORACLE： --时间转字符串 TO_CHAR(SYSDATE,‘YYYYMMDDHH24MISS‘) --字符串转时间 select TO_DATE(‘20140701125751‘,‘YYYYMMDDHH24MISS‘) from dual -- 2014-07-01 12:57:51 --查询table SELECT * FROM ALL_TABLES WHERE TABLE_NAME =‘{0}‘ --查询column SELECT aa.table_name AS tableename, aa.column_name AS colname, NVL (bb.comments, aa.column_name) AS colde...
一些常用是时间格式select TO_CHAR(SYSDATE,‘HH24:MI:SS AM‘) from dual ---12:56:40 下午select TO_CHAR(TO_DATE(‘21-1月-95‘),‘YYYY-MM-DD HH24:MI:SS AM‘) from dual---1995-01-21 00:00:00 上午select TO_CHAR(SYSDATE,‘DD "of" MONTH‘) from dual ---28 of 7月 select TO_CHAR(TO_DATE(‘25-7月-95‘),‘DD "of" MONTH‘) from dual ---25 of 7月 select to_char(sysdate, ‘ddspth‘) from dual ---twenty-eighthsel...
TO_CHAR(MAX(create_time),‘YYYY-MM-DD HH24:MI:SS‘) maxtime FROM EMPLOYEE; 最终把时间按照指定格式获取到oracle时间转换查询标签：本文系统来源：http://www.cnblogs.com/xjh713/p/5851777.html
:取得当前日期是本月的第几周 SQL> select to_char(sysdate,‘YYYYMMDD W HH24:MI:SS‘) from dual; TO_CHAR(SYSDATE,‘YY ------------------- 20030327 4 18:16:09 SQL> select to_char(sysdate,‘W‘) from dual; T - 4 2:取得当前日期是一个星期中的第几天,注意星期日是第一天 SQL> select sysdate,to_char(sysdate,‘D‘) from dual; SYSDATE T --------- - 27-MAR-03 5 类似:select to_char(sysdate,‘yyyy‘) ...
Oracle下时间转换在几种语言中的实现c shell perl php下的日期时间转换: 秒数与人类可读日期 scalar localtime 与 seconds since `00:00:00 1970-01-01 UTC' scalar localtime 26-byte string 与 seconds since `00:00:00 1970-01-01 UTC' （1970年1月1日凌晨零点以来的秒数） the number of seconds that have passed since the Epoch: 00:00:00 January 1, 1970, Coordinated Universal Time (UTC). c: 《Advanced Programming ...