Turns out that dateTime defaults to timestamp without time zone while timestamp defaults to timestamp with time zone on postgres.
This definition is working now for me:
{
field: 'time_of_call',
type: 'dateTime',
schema: {
default_value: null,
is_nullable: true
},
meta: {
interface: 'datetime',
display: 'datetime',
display_options: {
format: '24h',
},
note: 'Original datetime value from source',
}
}
Doesn’t answer the initial question, tho, how to define a specific postgres field type.
There's no way to define a specific Postgres type, as Directus abstracts away the data types to work across all databases
– rijkvanzanten