Could not construct a date from 2023-08-30 14:10:36.873 with format Y-m-d H:i:s

[jaydrogers]

Just for documentation reasons, a user in Discord reported this issue.

When switching from another PHP image to this one, they experienced this error message when this certain PHP code ran:

PHP Code

Period::make($timeLine->start_date, $timeLine->end_date ?? CarbonImmutable::now(), Precision::MINUTE(), Boundaries::EXCLUDE_END())]);

Error Message

Could not construct a date from 2023-08-30 14:10:36.873 with format Y-m-d H:i:s

[jaydrogers]

✅ Confirmed solution

• The user had to change the Driver used to connect to the SQL server

Their previous code

# Install SQL Server drivers
RUN apt-get update \
    && apt-get install -y software-properties-common unixodbc-dev php8.1-xml php-pear libcurl3-openssl-dev php8.1-dev php8.1-ldap php8.1-sybase \
    && pecl install sqlsrv \
    && pecl install pdo_sqlsrv \
    && printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/8.1/mods-available/sqlsrv.ini \
    && printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/8.1/mods-available/pdo_sqlsrv.ini \
    && phpenmod -v 8.1 sqlsrv pdo_sqlsrv

Their code that resolved it

RUN apt install -y \
    php-gd \
    php-common \
    php-mbstring \
    php8.1-odbc php8.1-pdo php8.1-xml php8.1-sybase \
    freetds-dev

More details on Discord

https://discord.com/channels/910287105714954251/1146541118218063943