Migrator
date()
Signature
Section titled “Signature”date() — returns any
Available in: tabledefinition
Category: Table Definition Functions
Description
Section titled “Description”date() is a table definition function used in a migration CFC to add one or more DATE columns to a table.
Parameters
Section titled “Parameters”| Name | Type | Required | Default | Description |
|---|---|---|---|---|
columnNames | string | no | — | |
default | string | no | — | |
allowNull | boolean | no | — |
Examples
Section titled “Examples”// In a migration CFC
t = createTable(name="events");
t.date(columnNames="startDate,endDate", default="", allowNull=false);
t.create();