`
weigang.gao
  • 浏览: 468545 次
  • 性别: Icon_minigender_1
  • 来自: 上海
文章分类
社区版块
存档分类
最新评论

format code appears twice

 
阅读更多

今天在执行脚本的时候,oracle报如下错误



Oracle

select to_date('2015/03/31 10:16:47','yyyy/MM/dd hh24:mi:ss') from dual;

 

问题] ORA-01810: format code appears twice 可能是像Java那样指定日期格式,比如:

to_date('2006-06-01 18:00:00' 'yyyy-mm-dd hh:MM:ss') 而在Oracle中的日期格式是不区分大小写的,

所以 mm 出现了两次。 正确的写法是: to_date('2006-06-01 18:00:00' 'yyyy-mm-dd hh:mi:ss')

  • 大小: 2.6 KB
分享到:
评论

相关推荐

    A LaTeX2e package for typesetting Matlab code as it appears

    A LaTeX2e package for typesetting Matlab code as it appears in the Matlab editor.zip

    Code Reading The Open Source Perspective

    Page 167 <br/>How do you comprehend code that appears to be doing five things in parallel? Page 132 <br/> You may read code because you have to-to fix it, inspect it, or improve it. You ...

    Aspose.word.dll文件,修复The document appears to be corrupted and cannot be loaded问题

    Aspose.word.dll文件,修复The document appears to be corrupted and cannot be loaded问题。 低版本的Aspose.word.dll动态链接库会存在这个bug,通过升级动态链接库就可以完美解决此问题,亲测有效,绝不忽悠你。

    code Reading 如何阅读代码

    If you are a programmer, you need this book. You've got a day to add a new feature in a 34,000-line program: ...How do you comprehend code that appears to be doing five things in parallel? Page 132

    Appears012

    AP8012中文技术手册,详细的技术参数,方便技术开发

    Generator features

    Either mode will give you access to the Code Generator features. ... Before creating the code, a report window appears so that you may verify that the code generated is as you expect it.

    programming.language.pragmatics.3rd solution and CD files

    programming.language.pragmatics.3rd solution and CD files include code, figures and... Code that appears both as an Example or Exercise and as a Figure is provided in a directory named after the Example.

    Draw a rotation of the Earth appears to be绘制地球

    绘制一个看起来是旋转的地球Draw a rotation of the Earth appears to be

    Aspose.Words2019-07-30.rar

    解决The document appears to be corrupted and cannot be loaded问题

    Aspose.Words20200216.zip

    Aspose.word.dll文件,修复The document appears to be corrupted and cannot be loaded问题。 低版本的Aspose.word.dll动态链接库会存在这个bug,通过升级动态链接库就可以完美解决此问题,亲测有效,绝不忽悠你。

    acpi控制笔记本风扇转速

    The disassembler now emits a comment if a buffer appears to be a ResourceTemplate, but cannot be disassembled as such because the EndTag does not appear at the very end of the buffer. AcpiExec - ...

    A.Collection.of.Bit.Programming.Interview.Questions.solved.in.C++

    Given an array of integers where all the numbers are appearing twice find the only two numbers which appears once Chapter 12. Multiply two numbers without using arithmetic operators Chapter 13. ...

    stringset:Golang实现的一组字符串

    Notice that "the" appears twice.ss.Put("the", "less", "I", "know", "the", "better")// Returns 5.fmt.Println(ss.Len())// Returns true.ss.Contains("better")// Remove some strings.ss.Remove("the", "less...

    Making Use of Python (2002).pdf

    Some content that appears in print may not be available in electronic books. Printed in the United States of America. 10 9 8 7 6 5 4 3 2 1 Introduction xi Scenario xxiii Chapter 1 An Introduction to ...

    Linux内核源代码分析 附赠光盘

    lckc_code All of the code included in this book in a single large file with the lines numbered--exactly as it appears in the first part of this book. lckc-find-line.el An Emacs Lisp file that defines ...

    The Pocket Guide To TCP/IP Sockets (C Version)

    Within the book, you will find C source code (appears to be ANSI/ISO C) for small functional clients and servers using both the TCP and UDP transports. The C code examples used in the book are ...

    解决最近升级iar出现的问题,J-Link弹出The connected J-Link is defective

    解决最近升级iar出现的问题,J-Link弹出The connected J-Link is defective,将这几个dll复制粘贴替换掉jLink安装目录(.../Segger/JlinkARMV.../)下的dll,实测可行

    follow-the-fork

    ^-^ SC2034: RED appears unused. Verify use (or export if used externally). In example.sh line 12: YELLOW=$(tput setaf 3) ^----^ SC2034: YELLOW appears unused. Verify use (or export if used externally)...

    Android Recipes, 4th Edition

    Android Recipes, Fourth Edition offers more ... Android appears complex, but offers a variety of organized development kits to those coming into Android with differing programming language skill sets.

    Teach Yourself Perl In 21 Days

    l Command input and anything that you are supposed to enter appears in a bold monospace font. You'll see this mainly in the Input-Output examples. l Placeholders in syntax descriptions appear in an ...

Global site tag (gtag.js) - Google Analytics