...
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 |
...