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 or datetime 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
)
Copied!
Configuration/TCA/tx_example_domain_model_foo.php 
'synced_at' => [
   'config' => [
      'type' => 'datetime',
      'dbType' => 'datetime',
      'nullable' => true,
   ],
],
Copied!

Time picker stored in a datetime field

ext_tables.sql 
CREATE TABLE tx_example_domain_model_foo (
   synced_at time default NULL
)
Copied!
Configuration/TCA/tx_example_domain_model_foo.php 
'synced_at' => [
   'config' => [
      'type' => 'datetime',
      'dbType' => 'time',
      'format' => 'time',
      'nullable' => true,
   ],
],
Copied!