`
weigang.gao
  • 浏览: 485922 次
  • 性别: 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
分享到:
评论

相关推荐

    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 ...

    A LaTeX2e package for typesetting Matlab code as it appears

    这将把名为"myCode.m"的Matlab源文件导入到文档中。 3. **特性与自定义** - **语法高亮**:matlab-prettifier能识别并高亮Matlab的关键字、函数、变量等,使得代码更易阅读。 - **代码风格**:用户可以设置代码...

    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

    yarn Retrying… info There appears to be trouble with your network connection.

    Vue CLI v4.2.2 Failed to check for updates :sparkles: Creating project in /home/syw/demo

    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.

    Aspose.Words2019-07-30.rar

    当你遇到"The document appears to be corrupted and cannot be loaded"的错误时,这通常意味着尝试打开或处理的Word文档存在损坏或格式不正确的问题。以下是一些可能的原因及相应的解决方案: 1. **文件损坏**:...

    Keil使用非正版Jlink

    Keil环境使用非正版Jlink,使用J-LINK下载或调试的时候会出现严重问题:The connected emulator is a J-link clone. 将文件解压,找到Keil安装目录,替换..\Keil\ARM\Segger

    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...

    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 ...

    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)...

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

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

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

    根据给定的信息,我们可以从标题、描述以及部分代码中提炼出与绘制地球旋转相关的知识点。 ### 绘制地球旋转的基本概念 #### 1.... - 地球可以用一个三维坐标系中的球体来近似表示。 - 通过定义球面坐标系(半径\( r...

Global site tag (gtag.js) - Google Analytics