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