Default value for datetime type not working for sqlite

[elfin-sbreuers]

The following annotation

    /**
     * @ORM\Column(name="changed_at", type="datetime", options={"default": 0})
     */
    private $changedAt;

should produce this outcome in sqlite

changed_at DATETIME DEFAULT CURRENT_TIMESTAMP

but produces

changed_at DATETIME DEFAULT '0' NOT NULL

in version 2.6.2.

Did something change in the API or is this a bug?

Thanks in advance.

[caciobanu]

You have to change your annotation to:

    /**
     * @ORM\Column(name="changed_at", type="datetime", options={"default": "CURRENT_TIMESTAMP"})
     */
    private $changedAt;

[Majkl578]

0 definitely doesn't look correct, was it ever working before?
There were some changes affecting CURRENT_TIMESTAMP, see #6698 / doctrine/dbal#2859, but those should be resolved as of DBAL 2.7.

[elfin-sbreuers]

@caciobanu: Thanks. Works like a charm.