FORMATDATE

Syntax

FORMATDATE(<date>;<string>)

Description

Converts dates to strings by applying a date and time parse pattern.

Examples

Column1

Pattern

FORMATDATE returns

19 Sep, 2008 11:13:27

dd-MM-yyyy hh:mm:ss

19-09-2008 11:13:27

25 Sep, 2005 12:23:05 PM

dd.MM.yyyy hh:mm:ss

25.09.05 12:23:05

15 Oct, 2002 10:35:08

dd-MM-yyyy

15-10-2002

25 Nov, 2010 11:56:13

yyyy-MM-dd

2010-11-25