I have a date string in a postgres db"2021-08-09 18:40:54.000+0000"and
am converting it to a dimension group with the following{ type: time
datatype: timestamp sql: TO_TIMESTAMP(replace(${TABLE}."DateField", 'T',
' '), 'YYYY-MM-DD HH24:MI:SS.0000');;...