DATE_FORMAT Operation

How to use the DATE_FORMAT operation for Computed Attributes

Definition

The DATE_FORMAT operation allows you to change the date format using the following tokens:

Configuring Date

Example

DATE_FORMAT(‘2020-03-22’, ‘%d-%b-%Y’)

Result:
22-Mar-2020

Syntax Guide

DATE_FORMAT(date, format)

date - the date to be formatted

format - the new format of the date

date-format