关于TO_DATE例子

SELECT TEST_STUDENT2.UUID,
       TEST_STUDENT2.NAME,
       TEST_STUDENT2.AGE,
       TEST_STUDENT2.BIRTHDAY,
       TEST_STUDENT2.HOBBY,
       TEST_STUDENT2.SJSC_SJ,
       TEST_STUDENT2.CREATE_DATE
  FROM NK_ZFFX.TEST_STUDENT2
 WHERE NK_ZFFX.TEST_STUDENT2.CREATE_DATE >=
       TO_DATE('01/01/1970 00:00:01', 'mm/dd/yyyy hh24:mi:ss')
   AND NK_ZFFX.TEST_STUDENT2.CREATE_DATE <=
       TO_DATE('01/06/2021 16:57:41', 'mm/dd/yyyy hh24:mi:ss');

  

posted @ 2021-01-06 14:48  技术研究与问题解决  阅读(81)  评论(0)    收藏  举报