:DATE(utc); will not work as expected, because u, t, and c alone are all recognized characters for datetime string. You can view all available format characters here: https://www.php.net/manual/en/datetime.format.php

I meant that if you type utc you don't get something related to the UTC time zone, but you get the concatenated result of each letter (something like 000000302021-11-20T15:32:35+00:00)

i did not seperate them u,t,c its a combine string UTC