Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index



Formatting Date and Time

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
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 StringFormat StringResult
16 April 2005date yyyy-mm-dd2005-04-16
16 April 2005date dd mmmm 'yy16 April '05
16 April 2005date 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 StringFormat StringResult
Test StringFormat StringResult
18:30:45time hh:mm:ss18:30:45
18:30:45time hh:mm:ss AMPM06:30:45 PM
18:30:45time h:mm:ss AMPM6:30:45 PM



All topics in the "Formatting Data" section: