dbType¶
type: string
Scope: Proc.
If set, the date or time will not be stored as timestamp, but as native
date
,time
ordatetime
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.)