<xmli:template xmlns:xmli="http://www.sourceforge.net/xmli" ccsid="819" format="none" > <!-- This example shows how to work with dates and times. --> <!-- Dates first --> <xmli:variable name="today" ><date:now/></xmli:variable> <xmli:variable name="yesterday" ><date:sub days="1"><xmli:value-of select="today" /></date:sub></xmli:variable> <xmli:variable name="lastWeek" ><date:sub days="7"><xmli:value-of select="today" /></date:sub></xmli:variable> <xmli:variable name="nextWeek" ><date:add days="7"><xmli:value-of select="today" /></date:add></xmli:variable> <xmli:variable name="nextMonth" ><date:add months="1"><xmli:value-of select="today" /></date:add></xmli:variable> <!-- Now Times --> <xmli:variable name="now" ><time:now/></xmli:variable> <xmli:variable name="hourAgo" ><time:sub hours="1"><xmli:value-of select="now" /></time:sub></xmli:variable> <xmli:variable name="tenMinutesAgo" ><time:sub minutes="10"><xmli:value-of select="now" /></time:sub></xmli:variable> <xmli:variable name="inTwoHours" ><time:add hours="2"><xmli:value-of select="now" /></time:add></xmli:variable> <xmli:variable name="inThirtySeconds" ><time:add seconds="30"><xmli:value-of select="now" /></time:add></xmli:variable> <html> <body> <h2>This page demonstrates how we can manipulate dates, times, and timestamps using the RPG extension</h2> <h3>Playing with dates</h3> Current Date is : <date:now /><br /> Job Date is : <date:job /><br /> today is : <xmli:value-of select="today" /><br /> yesterday is : <xmli:value-of select="yesterday" /><br /> last week is : <xmli:value-of select="lastWeek" /><br /> next week is : <xmli:value-of select="nextWeek" /><br /> The month of next week is : <date:subdt duration="months"><xmli:value-of select="nextWeek" /></date:subdt><br /> The month of next month is : <date:subdt duration="months"><xmli:value-of select="nextMonth" /></date:subdt><br /> The next year derived is : <date:subdt duration="years"><date:add years="1"><xmli:value-of select="today" /></date:add></date:subdt><br /> <h3>Playing with times</h3> Current Time is : <time:now /><br /> 1 hour ago was : <xmli:value-of select="hourAgo" /><br /> 10 minutes ago was: <xmli:value-of select="tenMinutesAgo" /><br /> In 2 hours it will be : <xmli:value-of select="inTwoHours" /><br /> In 30 seconds it will be : <xmli:value-of select="inThirtySeconds" /><br /> <h3>Formatting the current date in various character formats</h3> As *ISO : <date:format format="*ISO"><date:now /></date:format><br /> As *EUR : <date:format format="*EUR"><date:now /></date:format><br /> As *USA : <date:format format="*USA"><date:now /></date:format><br /> As *JIS : <date:format format="*JIS"><date:now /></date:format><br /> As *LONGJUL : <date:format format="*LONGJUL"><date:now /></date:format><br /> As *CYMD : <date:format format="*CYMD"><date:now /></date:format><br /> As *CDMY : <date:format format="*CDMY"><date:now /></date:format><br /> As *CMDY : <date:format format="*CMDY"><date:now /></date:format><br /> As *YMD : <date:format format="*YMD"><date:now /></date:format><br /> As *DMY : <date:format format="*DMY"><date:now /></date:format><br /> As *MDY : <date:format format="*MDY"><date:now /></date:format><br /> As *JUL : <date:format format="*JUL"><date:now /></date:format><br /> <h3>Formatting the current date in various numeric formats</h3> As *ISO0 : <date:format format="*ISO0"><date:now /></date:format><br /> As *EUR0 : <date:format format="*EUR0"><date:now /></date:format><br /> As *USA0 : <date:format format="*USA0"><date:now /></date:format><br /> As *JIS0 : <date:format format="*JIS0"><date:now /></date:format><br /> As *LONGJUL0 : <date:format format="*LONGJUL0"><date:now /></date:format><br /> As *CYMD0 : <date:format format="*CYMD0"><date:now /></date:format><br /> As *CDMY0 : <date:format format="*CDMY0"><date:now /></date:format><br /> As *CMDY0 : <date:format format="*CMDY0"><date:now /></date:format><br /> As *YMD0 : <date:format format="*YMD0"><date:now /></date:format><br /> As *DMY0 : <date:format format="*DMY0"><date:now /></date:format><br /> As *MDY0 : <date:format format="*MDY0"><date:now /></date:format><br /> As *JUL0 : <date:format format="*JUL0"><date:now /></date:format><br /> <h3>Formatting the current date using patterns</h3> As ZD Mmmmmmmmmz YYYY : <date:format toPattern="ZD Mmmmmmmmmz YYYY"><date:now /></date:format><br /> As ZD WWW Mmmmmmmmmz YYYY : <date:format toPattern="ZD WWW Mmmmmmmmmz YYYY"><date:now /></date:format><br /> As ZD Www Mmmmmmmmmz YYYY : <date:format toPattern="ZD Www Mmmmmmmmmz YYYY"><date:now /></date:format><br /> As ZD MMM YYYY : <date:format toPattern="ZD MMM YYYY"><date:now /></date:format><br /> <h3>Formatting a date by converting a string of the date in one format to the string in another format. The date is 18 November 2010.</h3> Converting from ZD Mmmmmmmmmz YYYY to Www ZDth Mmmmmmmmmz YYYY : <date:format fromPattern="ZD Mmmmmmmmmz YYYY" toPattern="Www ZDth Mmmmmmmmmz YYYY">18 November 2010</date:format> <h3>Converting using no date (defaults to today)</h3> Today as ZD Www Mmmmmmmmmz YYYY : <date:format toPattern="ZD Www Mmmmmmmmmz YYYY"/><br /> <h3>Formatting the current time in various character formats</h3> As *ISO : <time:format format="*ISO"><xmli:value-of select="now" /></time:format><br /> As *EUR : <time:format format="*EUR"><xmli:value-of select="now" /></time:format><br /> As *USA : <time:format format="*USA"><xmli:value-of select="now" /></time:format><br /> As *JIS : <time:format format="*JIS"><xmli:value-of select="now" /></time:format><br /> As *HMS : <time:format format="*HMS"><xmli:value-of select="now" /></time:format><br /> <h3>Formatting the current time in various numeric formats</h3> As *ISO0 : <time:format format="*ISO0"><xmli:value-of select="now" /></time:format><br /> As *EUR0 : <time:format format="*EUR0"><xmli:value-of select="now" /></time:format><br /> As *JIS0 : <time:format format="*JIS0"><xmli:value-of select="now" /></time:format><br /> As *HMS0 : <time:format format="*HMS0"><xmli:value-of select="now" /></time:format><br /> <h3>Formatting the current date and translating the separator from . to /</h3> As *EUR : <string:xlate from="." to="/"><date:format format="*EUR"><date:now /></date:format></string:xlate> <br /> </body> </html> <cgi:header>Content-Type: text/html</cgi:header> </xmli:template>