Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  Function inconsistency

    Posted 03/31/21 12:39 PM

    Hi,

     

    looking at the new time functions I stepped into a problem:

    DAYOFMONTH('01.03.2016') will work but

    DAYOFYEAR('01.03.2016') will return SQL-443

    Documentations says:

    An expression that returns a value of one of the following built-in data types: a DATE, TIMESTAMP, or a valid character string representation of a date or timestamp that is not a CLOB.

    For me '01.03.2016' is a valid date.

     

    It is the same for dayofweek_iso.

     

    This inconsistency should be fixed.

     

    best regards

    Michael Tiefenbacher


    #Db2


  • 2.  RE: Function inconsistency

    Posted 03/31/21 12:38 PM
    Hi Michael. I've gotten in touch with the development team responsible for those and will respond here as soon as I have any news. Thanks.


  • 3.  RE: Function inconsistency

    Posted 03/30/20 11:09 AM

    Hi Kelly,

    thanks - good to see a reaktion - the feedback on other questions is  poor....

     

    best regards

    Michael


    Original Message


Related Content