THEDATE Type: Adverb (String*24) Use: The date and time in string format. Null value: ' ' Verbs: GETDATE....Gets the date and time in a string form determined by the FORMAT adverb YYYY-MON-DD HH:MM:SS YYYYMONDD.HHMMSS YYYYMMDD.HHMMSS YYYYMMDDHHMMSS where MON is JAN, FEB, MAR, etc.