Skip to content

Instantly share code, notes, and snippets.

@ikennaokpala
Created June 19, 2011 11:19
Show Gist options
  • Save ikennaokpala/1034085 to your computer and use it in GitHub Desktop.
Save ikennaokpala/1034085 to your computer and use it in GitHub Desktop.
DATE AND TIME FORMAT CODES
DATE AND TIME FORMAT CODES
To Configure the Date/Time Display:
VIEW → GLOBAL OPTIONS → DISPLAY TAB
TOOLS → GLOBAL OPTIONS → DISPLAY TAB (VER 2.9.X)
Change the Time Format according to the codes listed below.
%a Abbreviated weekday name
%A Full weekday name
%b Abbreviated month name
%B Full month name
%c Date and time representation for your locale
%d Day of month as a decimal number (01-31)
%H Hour in 24-hour format (00-23)
%I Hour in 12-hour format (01-12)
%j Day of year as decimal number (001-366)
%m Month as decimal number (01-12)
%M Minute as decimal number (00-59)
%p Current locale’s A.M./P.M. indicator for 12-hour clock
%S Second as decimal number (00-59)
%U Week of year as decimal number, Sunday as first day of week (00-51)
%w Weekday as decimal number (0-6; Sunday is 0)
%W Week of year as decimal number, Monday as first day of week (00-51)
%x Date representation for current locale
%X Time representation for current locale
%y Year without century, as decimal number (00-99)
%Y Year with century, as decimal number
%z %Z Time-zone name or abbreviation, (no characters if time zone is unknown)
%% Percent sign
You can include text literals (such as spaces and colons) to make a neater display or for
padding between adjoining columns.
You can suppress the display of leading zeroes by using the "#" character (%#d, %#H,
%#I, %#j, %#m, %#M, %#S, %#U, %#w, %#W, %#y, %#Y)
EXAMPLES
Date Code Displays
%d-%m-%y 11-04-09
%b %#d, %Y - %a, %I:%M %p Apr 11, 2009 - Sat, 06:27 PM
%x at %I:%M:%S 04/18/09 at 04:09:39
Updated for Ver 2.9 TB 8/06/09
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment