databaserookies.wordpress.com/2014/11/30/sql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade

Preview meta tags from the databaserookies.wordpress.com website.

Linked Hostnames

10

Thumbnail

Search Engine Appearance

Google

https://databaserookies.wordpress.com/2014/11/30/sql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade

SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.

Recently on OTN, OP posted below scenario. When he ran below SQL, it failed with "ORA-01843" in oracle 12c version. select FISCAL_SYSTEM_PERIOD_CAL_YR_EQ, calendrical_equivalent from fiscal_system_periods where calendrical_equivalent > 0 and to_date(FISCAL_SYSTEM_PERIOD_CAL_YR_EQ || ', ' || 2014,'Month, YYYY') >= to_date('November, 2014','Month, YYYY') SQL comprise of two different condition on same table within "AND", condition 1 :…



Bing

SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.

https://databaserookies.wordpress.com/2014/11/30/sql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade

Recently on OTN, OP posted below scenario. When he ran below SQL, it failed with "ORA-01843" in oracle 12c version. select FISCAL_SYSTEM_PERIOD_CAL_YR_EQ, calendrical_equivalent from fiscal_system_periods where calendrical_equivalent > 0 and to_date(FISCAL_SYSTEM_PERIOD_CAL_YR_EQ || ', ' || 2014,'Month, YYYY') >= to_date('November, 2014','Month, YYYY') SQL comprise of two different condition on same table within "AND", condition 1 :…



DuckDuckGo

https://databaserookies.wordpress.com/2014/11/30/sql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade

SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.

Recently on OTN, OP posted below scenario. When he ran below SQL, it failed with "ORA-01843" in oracle 12c version. select FISCAL_SYSTEM_PERIOD_CAL_YR_EQ, calendrical_equivalent from fiscal_system_periods where calendrical_equivalent > 0 and to_date(FISCAL_SYSTEM_PERIOD_CAL_YR_EQ || ', ' || 2014,'Month, YYYY') >= to_date('November, 2014','Month, YYYY') SQL comprise of two different condition on same table within "AND", condition 1 :…

  • General Meta Tags

    12
    • title
      SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade. | Database and Migration Insights
    • charset
      UTF-8
    • robots
      max-image-preview:large
    • google-site-verification
      h4d_nQD3wz_iXqvdQGZTlUtZ7HfkNgfVhDI7Jy35nFc
    • generator
      WordPress.com

  • Open Graph Meta Tags

    10
    • og:type
      article
    • og:title
      SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.
    • og:url
      https://databaserookies.wordpress.com/2014/11/30/sql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade/
    • og:description
      Recently on OTN, OP posted below scenario. When he ran below SQL, it failed with “ORA-01843” in oracle 12c version. select FISCAL_SYSTEM_PERIOD_CAL_YR_EQ, calendrical_equivalent from fi…
    • og:site_name
      Database and Migration Insights

  • Twitter Meta Tags

    5
    • twitter:creator
      @mahtodeepak05
    • twitter:site
      @mahtodeepak05
    • twitter:text:title
      SQL worked fine on pre 12c but failed with “ORA-01843: not a valid month” after upgrade.
    • twitter:image
      https://databaserookies.wordpress.com/wp-content/uploads/2022/12/myavatar_2.png?w=240
    • twitter:card
      summary

  • Link Tags

    34
    • EditURI
      https://databaserookies.wordpress.com/xmlrpc.php?rsd
    • alternate
      https://databaserookies.wordpress.com/feed/
    • alternate
      https://databaserookies.wordpress.com/comments/feed/
    • alternate
      https://databaserookies.wordpress.com/2014/11/30/sql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade/feed/
    • alternate
      https://public-api.wordpress.com/oembed/?format=json&url=https%3A%2F%2Fdatabaserookies.wordpress.com%2F2014%2F11%2F30%2Fsql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade%2F&for=wpcom-auto-discovery

Emails

1
  • ?subject=%5BShared%20Post%5D%20SQL%20worked%20fine%20on%20pre%2012c%20but%20failed%20with%20%22ORA-01843%3A%20not%20a%20valid%20month%22%20after%20upgrade.&body=https%3A%2F%2Fdatabaserookies.wordpress.com%2F2014%2F11%2F30%2Fsql-worked-fine-on-pre-12c-but-failed-with-ora-01843-not-a-valid-month-after-upgrade%2F&share=email

Links

50