float(n): A floating-point number, with precision of at least n digits. date: A calendar date containing a (four-digit) year, month, and day of the month. time: The time of day, in hours, minutes, and seconds. A variant, time(p), can be used to specify the number of fractional digits for seconds (the default being 0). It is also possible to store time zone information along with the time.

timestamp: A combination of date and time. A variant, timestamp(p), can be used to specify the number of fractional digits for seconds (the default here being 6).