The Time data type allows the storage of a time value composed of hours, minutes, and seconds. A Time value must be enclosed with number signs (#)and in the format hh:mm:ss. The range of this data type goes from 00:00:00 to 23:59:59.

Default value

00:00:00

Example

#12:20:56#

See Also

Built-in Date & Time Functions | About Null Values | Available Data Types