Db\Column with type Db\Column::TYPE_TIMESTAMP and DEFAULT value as NULL or 0

Question

Db\Column with type Db\Column::TYPE_TIMESTAMP and DEFAULT value as NULL or 0

mikkiek Mar '16

Created Mar '16	Last Reply Jun '16	Replies 1	Views 528	Votes 0

mikkiek 5.4k

Mar '16

Hello,

How can i use Db\Column to create a field (using createTable method) with NULL or 0 value? Right now all variants cause an error and according zep code of method https://github.com/phalcon/cphalcon/blob/master/phalcon/db/dialect/mysql.zep default value wrapped by quotes. Temporary i've solved a problem by following way, but i'll be happy if someone can introduce a better solution.

        new Db\Column("active_to",
            [
                "type"    => Db\Column::TYPE_TIMESTAMP,
                'default' => '0000-00-00 00:00:00'
            ]
        ),

Thank you.

fgomes · Answer 1 · 2016-06-15T10:41:55-07:00

if you don't have a value to insert in table, you must save null in timestamp column, It's the best solution, because 0000-00-00 00:00:00 was when Jesus Christ born. OK? kkkkk