Skip to content

Creation Time

The creation time field saves the time when the record was created (automatically generated)

Description

ItemContent
CategoryStatic Field
SortableYes
FilterableYes
Supported Filter TypesEqual, Not Equal, Empty, Not Empty, Less Than, Greater Than, Less Than or Equal, Greater Than or Equal, Within Range, Not Within Range

Settings

SettingDescription
Display formatFormat of the creation time display
Custom display formatUse expressions to customize rendering display content

Database Storage Format

Field TypeDescription
timestamp(6)Store date and time

Data Format

Note

  • If data already exists in the table and then the creation time field is added, the creation time field of this original data is null. If you need to update this data, you need to call the script function
javascript
informat.table.update();
//Or
informat.table.updateList();

Usage Examples

Display format

create-time-1.png

Custom display format

create-time-2.png

js
${Misc.formatDate(record.formatDateDiy,'yyyy-MM-dd HH:mm:ss SSS')}
${Misc.formatDate(record.formatDateDiy,'Now is yyyy year MM month dd day HH hour mm minute ss second SSS millisecond')}

Display Effect

Display format

create-time-3.png

Custom display format

create-time-4.pngcreate-time-5.png