Skip to main content

FORMAT_DATETIME

Convert a datetime from one format to another

Example Usage​

FORMAT_DATETIME("12/21/22 15:35", "%m/%d/%y %H:%M", "Y-%m-%d %H:%M") 

Overview​

Function signature
FORMAT_DATETIME(value, mask, targetmask)

Category
Date

Return data type
date

Arguments​

NameDataTypeList Options                          Description
valuestringSource value as a string
maskstringSource mask for incoming value
targetmaskstringTarget mask for output