 |
Online Help System
|
 |
Back to Brilliant Database Web-Site |
Write to Support |
Help Index
Formatting Date and Time
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
|
See Also:
Using Formatting
Formatting Text
Text Formulas
|
