dbType

type:

string

Scope:

Proc.

If set, the date or time will not be stored as timestamp, but as native date, time or datetime field in the database. Keep in mind that no timezone conversion will happen.

Examples

Datetime:

ext_tables.sql:

CREATE TABLE tx_example_domain_model_foo (
   synced_at datetime default NULL
)

Configuration/TCA/tx_example_domain_model_foo.php:

'synced_at' => [
   'config' => [
      'type' => 'input',
      'renderType' => 'inputDateTime',
      'dbType' => 'datetime',
      'eval' => 'datetime,null',
   ],
],

Time:

ext_tables.sql:

CREATE TABLE tx_example_domain_model_foo (
   synced_at time default NULL
)

Configuration/TCA/tx_example_domain_model_foo.php:

'synced_at' => [
   'config' => [
      'type' => 'input',
      'dbType' => 'time',
      'eval' => 'time,null',
   ],
],

Note

When this property is not set you have to add int to the eval option. (Otherwise the database might complain about invalid values.)