dbType¶
- dbType¶
- Path
$GLOBALS['TCA'][$table]['columns'][$field]['config']
- 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¶
Date and time picker stored in a datetime field¶
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 picker stored in a datetime field¶
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.)