TRUNC(TO_DATE('24-Nov-1999 08:00 pm'),'dd-mon-yyyy hh:mi am')
='24-Nov-1999 12:00:00 am'
TRUNC(TO_DATE('24-Nov-1999 08:37 pm','dd-mon-yyyy hh:mi am'),'hh') ='24-Nov-1999 08:00:00 am'
哪位大侠给解释下,我是菜鸟,不明白to_date()是怎么转换am、pm时间的,百度google了没找到我想要的东西,先谢过了!
='24-Nov-1999 12:00:00 am'
TRUNC(TO_DATE('24-Nov-1999 08:37 pm','dd-mon-yyyy hh:mi am'),'hh') ='24-Nov-1999 08:00:00 am'
哪位大侠给解释下,我是菜鸟,不明白to_date()是怎么转换am、pm时间的,百度google了没找到我想要的东西,先谢过了!
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as SYSSQL> select TO_DATE('24-Nov-1999 08:37 pm','dd-mon-yyyy hh:mi am') from dual;select TO_DATE('24-Nov-1999 08:37 pm','dd-mon-yyyy hh:mi am') from dualORA-01843: 无效的月份SQL>
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as SYSSQL> select TO_DATE('24-Nov-1999 08:37 pm','dd-mon-yyyy hh:mi am') from dual;select TO_DATE('24-Nov-1999 08:37 pm','dd-mon-yyyy hh:mi am') from dualORA-01843: 无效的月份SQL> alter session set nls_language=AMERICAN;Session alteredSQL> select TO_DATE('24-Nov-1999 08:37 pm','dd-mon-yyyy hh:mi am') from dual;TO_DATE('24-NOV-199908:37PM','
------------------------------
1999/11/24 20:37:00SQL>
这个语句是什么意思?属于DDL还是什么?