DATETOTEXT

Converts a datetime value into a text with a user-defined format.

Syntax

DATETOTEXT(datetime, formatstring)

• datetime - the datetime value to be converted into a text - Value type: datetime

• formatstring - the format string for the conversion of datetime - Value type: text

The conversion by formatstring follows these rules (case-sensitive):

1. yyyy - is replaced by the year in 4 digits (e.g. 2024)

2. yy - is replaced by the year in 2 digits (the last two digits of the year, e.g. 24)

3. mm - is replaced by the month in 2 digits (e.g. 01, 02, 12)

4. m - is replaced by the month in 1-2 digits (e.g.1, 2, 12)

5. dd - is replaced by the day in 2 digits (e.g. 01, 02, 27)

6. d - is replaced by the day in 1-2 digits (e.g.1, 2, 27)

7. HH - is replaced by the hour in 2 digits (e.g. 01, 02, 15)

8. H - is replaced by the hour in 1-2 digits (e.g.1, 2, 15)

9. MM - is replaced by the minute in 2 digits (e.g. 01, 02, 45)

10. M - is replaced by the minute in 1-2 digits (e.g. 01, 02, 45)

11. SS - is replaced by the seconds in 2 digits (e.g. 01, 02, 23)

12. S - is replaced by the seconds in 1-2 digits (e.g. 01, 02, 23)

Remark

• datetime is always in UTC time. If the text is to be converted to local time, datetime must be adjusted using the GETTIMEZONEOFFSET function.

Example

DATETOTEXT with one value: