[asterisk-bugs] [JIRA] (ASTERISK-26001) Asterisk ignores dateformat setting in cel.conf and default behaviour wrong

[Richard Wilkinson (JIRA)]

Richard Wilkinson created ASTERISK-26001:
--------------------------------------------

             Summary: Asterisk ignores dateformat setting in cel.conf and default behaviour wrong
                 Key: ASTERISK-26001
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26001
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
    Affects Versions: 13.8.2
         Environment: Centos Linux
            Reporter: Richard Wilkinson
            Severity: Minor


Asterisk ignores the dateformat configuration parameter in cel.conf when using ODBC with MySQL.  This may be apparant with other DB backends but I don't have means to test those.

Asterisk is pushing the date string to to the database incorrectly.  I have ruled out MySQL reformatting the unix timestamp.

Documentation states omitting the parameter defaults it to seconds.microseconds.

Whatever the value is specified, the format actually used is yyyy-mm-dd hh:mm:ss.microseconds.

Here are some examples:-

Parameter:  Omitted
Date Generated:  2016-05-06 18:58:21.416305

Parameter: dateformat = %s
Date Generated:  2016-05-06 18:58:21.416305

Parameter: dateformat = "%F %T"
Date Generated:  2016-05-06 18:58:21.416305

It is completely ignoring what dateformat is set to.






--
This message was sent by Atlassian JIRA
(v6.2#6252)