length of date in sql code example

Example: sql What type is that value?

SELECT TYPEOF(value);