Basic Information

To learn more about how and where you can use formatting, see the Using Formatting section.

Date Format

This format is used for formatting dates.

Format string example: date dd-mm-yy

• m - numeric representation of a month, without leading zeros (1, 2, 12);
• mm - numeric representation of a month, with leading zeros (01, 02, 12);
• mmm - short textual representation of a month, three letters (Jan, Feb, Dec);
• mmmm - long textual representation of a month (January, February, December);
• d - day of the month without leading zeros (1, 2, 24);
• dd - day of the month with leading zeros (01, 02, 24);
• ddd - textual representation of a day, three letters (Mon, Tue, Sun);
• dddd - textual representation of a day (Monday, Tuesday, Sunday);
• yy - year, 2 characters (99, 00, 04);
• yyyy - year, 4 characters (1999, 2000, 2004).

Examples:

Test String	Format String	Result
16 April 2005	date yyyy-mm-dd	2005-04-16
16 April 2005	date dd mmmm 'yy	16 April '05
16 April 2005	date dd mmm yyyy (dddd)	16 Apr 2005 (Sunday)

Time Format

This format is used for formatting time.

Format string example: time hh:mm:ss AMPM

• h - hour without leading zeros (2, 11);
• hh - hour with leading zeros (02, 11);
• m - minute without leading zeros (2, 59);
• mm - minute with leading zeros (02, 59);
• s - second without leading zeros (2, 55);
• ss - second with leading zeros;(02, 55);
• Use the AMPM string to show time in the AmPm format.

Examples:

Test String	Format String	Result
Test String	Format String	Result
18:30:45	time hh:mm:ss	18:30:45
18:30:45	time hh:mm:ss AMPM	06:30:45 PM
18:30:45	time h:mm:ss AMPM	6:30:45 PM