Skip to content

Migrator

time()

time() — returns any

Available in: tabledefinition Category: Table Definition Functions

Adds one or more TIME columns to a table definition in a migration. Only available in a migrator CFC.

NameTypeRequiredDefaultDescription
columnNamesstringno
defaultstringno
allowNullbooleanno
1. Add a simple time column
t.time("startTime")

2. Add multiple time columns
t.time("opensAt, closesAt")

3. Add a time column with a default value
t.time(columnNames="reminderAt", default="09:00:00")

4. Add a nullable time column
t.time(columnNames="lunchBreak", allowNull=true)