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