Skip to content

Error with %d format symbol inside select clause #330

Description

@KarelWintersky
$dbh = new \PDO(sprintf("mysql:host=%s;port=%s;dbname=%s", 'localhost', 3306, 'database'), 'root', 'password');

$query = new \Envms\FluentPDO\Query($dbh);
$query = $query;

$query = $query
  ->from("articles")
  ->select("
        *,
        DATE_FORMAT(cdate, '%H:%i %d.%m.%Y') AS cdate2,
        DATE_FORMAT(cdate, '%d.%m.%Y') AS cdate3,
        ", true
    );

var_dump($query->getQuery());

Result is:

SELECT
        *,
        DATE_FORMAT(cdate, '%H.%i %m.%Y') AS cdate2,
        DATE_FORMAT(cdate, %m.%Y') AS cdate3,
FROM articles
    LEFT JOIN H ON H.articles_id = articles.id
    LEFT JOIN d ON d.id = articles.d_id

WTF? O.O

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions