Created
June 19, 2011 11:19
-
-
Save ikennaokpala/1034085 to your computer and use it in GitHub Desktop.
DATE AND TIME FORMAT CODES
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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