regex pattern does not support sql casting using :: operator for example select mydate::date from mytable;