×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Las Vegas

oracle date and coldfusion date

anno(烦人)
本文发表在 rolia.net 枫下论坛This is a pretty funny story:
I'm using ColdFusion and Oracle as db server.
in my application.cfm I set db date format as this.

ALTER SESSION SET NLS_DATE_FORMAT = 'MM-DD-YYYY HH24:MI:SS'


then when I insert '03/18/02' into a table column(date type),
oracle take it as 03/18/0002, this is fine still although it's already becoming funny.
The joke is here:
when you get this date out and use couldfuion
dateformat(date_value, "MM/DD/YYYY") to show on the page,
It's 03/18/2002 now.

That means, acturally in oracle, you have 03/18/0002, but you can see only 03/18/2002 on the page.

even more than this, when I use sql plus or other tools, most of the tools will show only
03/18/02 or change this date to 03/18/2002.

It gave me a realy hard time to find out what happend in the system.
Cause before you realize this is the problem, you can't find out how come what you can see
03/18/2002 and another 03/18/2002 is not the same day.....


Don't know who had this before, maybe there's some solutions already.

Peter.更多精彩文章及讨论，请光临枫下论坛 rolia.net
(#377082@0)
Last Updated: 2002-2-22
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / oracle date and coldfusion date -anno(烦人); 2002-2-22 {1057} (#377082@0)
    本文发表在 rolia.net 枫下论坛This is a pretty funny story:
    I'm using ColdFusion and Oracle as db server.
    in my application.cfm I set db date format as this.

    ALTER SESSION SET NLS_DATE_FORMAT = 'MM-DD-YYYY HH24:MI:SS'


    then when I insert '03/18/02' into a table column(date type),
    oracle take it as 03/18/0002, this is fine still although it's already becoming funny.
    The joke is here:
    when you get this date out and use couldfuion
    dateformat(date_value, "MM/DD/YYYY") to show on the page,
    It's 03/18/2002 now.

    That means, acturally in oracle, you have 03/18/0002, but you can see only 03/18/2002 on the page.

    even more than this, when I use sql plus or other tools, most of the tools will show only
    03/18/02 or change this date to 03/18/2002.

    It gave me a realy hard time to find out what happend in the system.
    Cause before you realize this is the problem, you can't find out how come what you can see
    03/18/2002 and another 03/18/2002 is not the same day.....


    Don't know who had this before, maybe there's some solutions already.

    Peter.更多精彩文章及讨论，请光临枫下论坛 rolia.net
    • a bit of confusion on what you're talking about, as far as date format concerned, all the systems have proper date convert functionality, all you have to do is -rootbear(啤酒晕头); 2002-2-22 {363} (#377121@0)
      get familiar with the fact that how the date stored internally, say, date in oracle, stores date and time, so when you compare 2 same dates, don't forget the time portion, if you really got a hard time, try to use string as a intermediate variable, and use convert functions to the proper database format, don't confuse yourself before you confuse the machine.

More Topics

  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
  • 请问web developer和software developer技术上有什么区别？
  • Elon Musk 带着川普总统奔向火星了。
    • 枫下论坛主坛 /  工作学习 /  IT技术讨论