Cannot set default Date on timestamp column.

[estaub]

Environment

Knex version: 0.16.3
Database + version: Postgresql 10.3
OS: MacOS

Problem

Trying to set a Date as timestamp column default fails:

table.timestamp('boundary_latest_update').defaultTo(new Date(0))

complains

"boundary_latest_update" timestamptz default 'Wed Dec 31 1969 19:00:00 GMT-0500 (EST)', "json" jsonb) - time zone "gmt-0500" not recognized

This works:

defaultTo(k.raw('timestamp without time zone \'1970-01-01 00:00\''))

[elhigu]

Looks like .defaultTo is not using bindings to pass the value (not sure if db drivers even support using bindinds there).

That could be fixed or documented better.

Anyways it seems that if object is passed there .toString() is used to convert the value to SQL and server does not understand that timeformat. You could do .defaultTo(new Date(0).toISOString()) to use iso format for passing the datetime...