Converting String to Date

[villibord]

dimension: ticket_start_date{
    type: date_time
    sql:  cast(${TABLE}.start as timestamp);;

I’ve tried using the function above to convert a string into a datetime however the string format is something like: 2020-09-12T16:00:00.00Z. This function doesn’t parse the time only the date so it returns 2020-09-12 00:00:00. 

Can someone help parse this out