Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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



  • No labels