I can't insert NULL values into datetime2 fields in SQL Server

Question

Hi!

I'm using CakePHP. When trying to insert a null value into a field it turns into 1900-01-01 00:00:00.

Here's a sample of my code:

$this->save(array(
        'date_signed' => null
    ));

What seems to be the error and how do I fix it? Thanks in advance!

Answer 1

This is how my db column looks (in phpMyAdmin):

FIELD      TYPE      NULL   DEFAULT
paid_date  datetime  Yes    NULL