Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Unanswered: SQL0206N "31 mars 2014" is not valid in the context

    Hi all,
    when queyring I receive the following :
    ------------------------------ Commands Entered ------------------------------
    select PRCSINSTANCE, rundttm from psprcsrqst where rundttm between "31 mars 2014" and "01 avril 2014";
    ------------------------------------------------------------------------------
    select PRCSINSTANCE, rundttm from psprcsrqst where rundttm between "31 mars 2014" and "01 avril 2014"
    SQL0206N "31 mars 2014" is not valid in the context where it is used.
    SQLSTATE=42703

    SQL0206N "31 mars 2014 " is not valid in the context where it is used.

    In table the value in RUNDTTM is displayed like :
    31 mars 2014
    1 Avr. 2014

    Any Idea ? Thanks.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    See if this works (note single quote):

    select PRCSINSTANCE, rundttm from psprcsrqst where rundttm between '2014-03-31' and '2014-04-01';
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •