svn commit - mysqldoc@docsrva: r7252 - trunk/dynamic-docs/miscdata

[plavin]

Author: plavin
Date: 2007-07-27 17:39:50 +0200 (Fri, 27 Jul 2007)
New Revision: 7252

Log:
Fill in date formats


Modified:
   trunk/dynamic-docs/miscdata/dateformats.xml


Modified: trunk/dynamic-docs/miscdata/dateformats.xml
===================================================================
--- trunk/dynamic-docs/miscdata/dateformats.xml	2007-07-27 11:15:10 UTC (rev 7251)
+++ trunk/dynamic-docs/miscdata/dateformats.xml	2007-07-27 15:39:50 UTC (rev 7252)
Changed blocks: 3, Lines Added: 421, Lines Deleted: 4; 13407 bytes

@@ -1,7 +1,7 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE dateformats SYSTEM "dateformats.dtd">
 <dateformats>
-<dateformat id="hour-range-twelve">
+<dateformat id="hour-twelve-double">
   <name>Hour (01..12)</name>
   <description>Hour, two digits, in the range one (01) to twelve
(12)</description>
   <formats>

@@ -17,8 +17,8 @@
   </versions>
 </dateformat>
 <dateformat id="day-week-numeric">
-  <name>Day of the week</name>
-  <description>Day of the week where 0 = Sunday </description>
+  <name>Numeric day of the week</name>
+  <description>Numeric day of the week where 0 = Sunday </description>
   <formats>
     <format text="W" introduced="4.1"/>
   </formats>

@@ -33,5 +33,422 @@
     <manual version="5.2"/>
   </versions>
 </dateformat>
-
+  <dateformat id="day-week-name-abbreviated">
+    <name>Abbreviated weekday name</name>
+    <description>Abbreviated weekday name (Sun ... Sat)</description>
+    <formats>
+      <format text="a" />
+    </formats>
+    <values type="enum">
+      <enum>Sun</enum>
+      <enum>Sat</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="month-name-abbreviated">
+    <name>Abbreviated month name</name>
+    <description>Abbreviated month name (Jan..Dec)</description>
+    <formats>
+      <format text="b"/>       
+    </formats>
+    <values type="enum">
+      <enum>Jan</enum>
+      <enum>Dec</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="month-numeric-single">
+    <name>Month (0..12)</name>
+    <description>Month, single digit numeric (0..12)</description>
+    <formats>
+      <format text="c" />
+    </formats>
+    <values type="numeric" min="1" max="12"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="day-month-numeric-suffix">
+    <name>Day of the month with English suffix</name>
+    <description>Day of the month with English suffix (0th, 1st, 2nd, 3rd,
…)</description>
+    <formats>
+      <format text="D"/>
+    </formats>
+    <values type="enum">
+      <enum>0th</enum>
+      <enum>31st</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="day-month-numeric-double">
+    <name>Day of the month (00..31)</name>
+    <description>Day of the month, numeric (00..31)</description>
+    <formats>
+      <format text="d" />
+    </formats>
+    <values type="numeric" min="00" max="31"/>   
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="time-12-hour">
+    <name>Time, 12-hour </name>
+    <description>Time, 12-hour (hh:mm:ss followed by AM or PM)</description>
+    <formats>
+      <format text="r" />
+    </formats>
+    <values type="enum">
+      <enum>01:00:00 AM</enum>
+      <enum>12:59:59 PM</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="day-month-numeric-single">
+    <name>Day of the month (0..31)</name>
+    <description>Day of the month, numeric (0..31)</description>
+    <formats>
+      <format text="e"/>
+    </formats>
+    <values type="enum" min="0" max="31"/>   
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="microseconds">
+    <name>Microseconds</name>
+    <description>Microseconds (000000..999999)</description>
+    <formats>
+      <format text="f" />
+    </formats>
+    <values type="numeric" min="000000" max="999999"/>   
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="hour-twenty-four-double">
+    <name>Hour (00..23)</name>
+    <description>Hour (00..23)</description>
+    <formats>
+      <format text="H" />
+    </formats>
+    <values type="numeric" min="00" max="23"/>    
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="minutes-numeric">
+    <name>Minutes, numeric (00..59</name>
+    <description>Minutes, numeric (00..59</description>
+    <formats>
+      <format text="i" />
+    </formats>
+    <values type="numeric" min="00" max="59"/>    
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="numeric-day-of-year">
+    <name>Day of year (001..366)</name>
+    <description>Day of year (001..366)</description>
+    <formats>
+      <format text="j"/>
+    </formats>
+    <values type="numeric" min="001" max="0366">      
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="hour-twenty-four-single">
+    <name>Hour (0..23)</name>
+    <description>Hour (0..23)</description>
+    <formats>
+      <format text="k"/>
+    </formats>
+    <values type="numeric" min="0" max="23"/>    
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="hour-twelve-single">
+    <name>Hour (1..12)</name>
+    <description>Hour (1..12)</description>
+    <formats>
+      <format text="l"/>
+    </formats>
+    <values type="numeric" min="1" max="12"/>    
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="month-name">
+    <name>Month name (January..December)</name>
+    <description>Month name (January..December)</description>
+    <formats>
+      <format text="M"/>
+    </formats>
+    <values type="enum"> 
+      <enum>January</enum>
+      <enum>December</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="month-numeric-double">
+    <name>Month, numeric (00..12)</name>
+    <description>Month, numeric (00..12)</description>
+    <formats>
+      <format text="m"/>
+    </formats>
+    <values type="numeric" min="00" max="12"/>    
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="meridian">
+    <name>AM or PM</name>
+    <description>AM or PM</description>
+    <formats>
+      <format text="p"/>
+    </formats>
+    <values type="enum">
+      <enum>AM</enum>
+      <enum>PM</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="seconds">
+    <name>Seconds</name>
+    <description>Seconds (00..59)</description>
+    <formats>
+      <format text="s"/>
+      <format text="s"/>
+    </formats>
+    <values  type="numeric" min="00" max="59"/>    
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="hour-twenty-four">
+    <name>Time, 24-hour (hh:mm:ss)</name>
+    <description>Time, 24-hour (hh:mm:ss)</description>
+    <formats>
+      <format text="T"/>
+    </formats>
+    <values  type="mixed"> 
+      <enum>00:00:00</enum>
+      <enum>23:59:59</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="week-Sunday-start">
+    <name>Week (00..53), where Sunday is the first day of the week</name>
+    <description>Week (00..53), where Sunday is the first day of the
week</description>
+    <formats>
+      <format text="U"/>
+    </formats>
+    <values type="numeric" min="00" max="53"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="week-Monday-start">
+    <name>Week (00..53), where Monday is the first day of the week</name>
+    <description>Week (00..53), where Monday is the first day of the
week</description>
+    <formats>
+      <format text="u"/>
+    </formats>
+    <values type="numeric" min="00" max="53"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="week-Sunday-start-X">
+    <name>Week (01..53), where Sunday is the first day of the week; used with
%X</name>
+    <description>Week (01..53), where Sunday is the first day of the week; used
with %X</description>
+    <formats>
+      <format text="V"/>
+    </formats>
+    <values type="numeric" min="01" max="53"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="week-Monday-start-x">
+    <name>Week (01..53), where Monday is the first day of the week; used with
</name>
+    <description>Week (01..53), where Monday is the first day of the week; used
with </description>
+    <formats>
+      <format text="v"/>
+    </formats>
+    <values type="numeric" min="01" max="53"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="weekday-name">
+    <name>Weekday name (Sunday..Saturday)</name>
+    <description>Weekday name (Sunday..Saturday)</description>
+    <formats>
+      <format text="W"/>
+    </formats>
+    <values type="enum">
+      <enum>Sunday</enum>
+      <enum>Saturday</enum>
+    </values>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="numeric-day-of-week">
+    <name>Day of the week (0=Sunday..6=Saturday)</name>
+    <description>Day of the week (0=Sunday..6=Saturday)</description>
+    <formats>
+      <format text="w"/>
+    </formats>
+    <values type="numeric" min="0" max="6"/>    
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="year-week-sunday-start">
+    <name>Year for the week where Sunday is the first day of the week, numeric,
four digits; used with %V</name>
+    <description>Year for the week where Sunday is the first day of the week,
numeric, four digits; used with %V</description>
+    <formats>
+      <format text="X"/>
+    </formats>
+    <values type="numeric" min="0000"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="year-four-digits">
+    <name>Year, numeric, four digits</name>
+    <description>Year, numeric, four digits</description>
+    <formats>
+      <format text="Y"/>
+    </formats>
+    <values type="numeric" />
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="year-week-monday-start">
+    <name>Year for the week, where Monday is the first day of the week, numeric,
four digits; used with %v</name>
+    <description>Year for the week, where Monday is the first day of the week,
numeric, four digits; used with %v</description>
+    <formats>
+      <format text="x"/>
+    </formats>
+    <values type="numeric"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
+  <dateformat id="year-two-digits">
+    <name>Year, numeric (two digits)</name>
+    <description>Year, numeric (two digits)</description>
+    <formats>
+      <format text="y"/>
+    </formats>
+    <values type="numeric"/>
+    <versions>
+      <manual version="4.1"/>
+      <manual version="5.0"/>
+      <manual version="5.1"/>
+      <manual version="5.2"/>
+    </versions>
+  </dateformat>
 </dateformats>
\ No newline at end of file