CAST () SQL's CAST () function is similar to CONVERT (); it lacks the date formatting capabilities CONVERT () has, but otherwise works in a similar fashion.