Date & Time

The Created Time field in NocoDB shows when each record was created; learn how to show it and how it works.

The Date Time field in NocoDB stores a date and a time in one field; learn how to create it and which date and time formats it supports.

The Date field in NocoDB stores date values; learn how to create it and which date formats it supports, including Jalali formats.

The Duration field in NocoDB stores a length of time; learn how to create it and which duration formats it supports.

The Last Modified Time field in NocoDB shows when a record last changed, for the whole record or for specific fields only.

The Time field in NocoDB stores a time value in a 12-hour format; learn how to create it.

Date functions for NocoDB formula fields, such as DATETIME_DIFF, DATEADD, NOW, WEEKDAY and DATETIME_FORMAT, with syntax and samples.