Oracle:如何在TO_DATE转换中指定字符文字? [英] Oracle: How can I specify character literals in TO_DATE conversions?

问题描述

如何在日期说明中指定字符文字?在第二个示例中，我想跳过T和Z.

How do I specify character literals in a date specification? In the second example, I would like to skip the T and Z.

select to_date('2015-04-06 19:56:30', 'YYYY-MM-DD HH24:MI:SS') from dual;

    2015-04-06 19:56:30                                  

select to_date('2015-04-06 19:56:30', 'YYYY-MM-DDTHH24:MI:SSZ') from dual;

    ORA-01821: date format not recognized

推荐答案

您可以将文字用双引号引起来:

You can enclose the literals in double quotes:

SQL> select to_date('2015-04-06T19:56:30Z', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') from dual;

TO_DATE('2015-04-0
------------------
06-APR-15

这篇关于Oracle:如何在TO_DATE转换中指定字符文字?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！