$Sir ND2Date: Difference between revisions
m (1 revision) |
mNo edit summary |
||
Line 2: | Line 2: | ||
<span class="pageSubtitle"><section begin="desc" />Convert datetime number of days to string<section end="desc" /></span> | <span class="pageSubtitle"><section begin="desc" />Convert datetime number of days to string<section end="desc" /></span> | ||
<p class="warning">Most Sirius $functions have been deprecated in favor of Object Oriented methods. | <p class="warning">Most Sirius $functions have been deprecated in favor of Object Oriented methods. There is currently no OO equivalent for the $Sir_ND2Date function.</p> | ||
The $Sir_ND2Date function expects a numeric datetime argument containing a number of days since January 1, 1900, and a datetime format string. It returns the date represented by the first argument, in the format corresponding to the second argument. $Sir_ND2Date accepts an optional error control string and returns the null string if an error is detected. | |||
==Syntax== | ==Syntax== | ||
<p class="syntax"><section begin="syntax" /> %dat = $Sir_ND2Date(datn, fmt, errctl) | <p class="syntax"><section begin="syntax" /> %dat = $Sir_ND2Date(datn, fmt, errctl) | ||
Line 12: | Line 11: | ||
<p class="caption">$Sir_ND2Date Function | <p class="caption">$Sir_ND2Date Function | ||
</p> | </p> | ||
where | where | ||
<table class="syntaxTable"> | <table class="syntaxTable"> | ||
<tr><th>datn</th> | <tr><th>datn</th> | ||
Line 22: | Line 23: | ||
<tr><th>%dat</th> | <tr><th>%dat</th> | ||
<td>set to the datetime value string, using format specified by '''fmt''', corresponding to '''datn''', unless an error is detected. | <td>set to the datetime value string, using format specified by '''fmt''', corresponding to '''datn''', unless an error is detected. | ||
</td></tr></table> | </td></tr> | ||
</table> | |||
For example, the following fragment prints the string <tt>07/31/84</tt>: | For example, the following fragment prints the string <tt>07/31/84</tt>: | ||
Line 32: | Line 33: | ||
</p> | </p> | ||
Error conditions are shown in the following figure.<p> | |||
Error conditions are shown in the following figure | |||
<ul> | <ul> | ||
<li>'''fmt''' is not a valid datetime format. | <li>'''fmt''' is not a valid datetime format. | ||
<li>'''datn''' out of range. | <li>'''datn''' out of range. | ||
</ul> | </ul> | ||
</p> | </p> | ||
<p class="caption"> $Sir_ND2Date returns a null string in the following cases:</p> | <p class="caption"> $Sir_ND2Date returns a null string in the following cases:</p> | ||
Notes: The inverse of this $function is $Sir_Date2ND. | |||
<ul class="smallAndTightList"> | <ul class="smallAndTightList"> | ||
<li>[[Sirius functions]]</li> | <li>[[Sirius functions]]</li> | ||
Line 59: | Line 53: | ||
<li>[[Japanese functions]]</li> | <li>[[Japanese functions]]</li> | ||
<li>[[Sir2000 Field Migration Facility]]</li> | <li>[[Sir2000 Field Migration Facility]]</li> | ||
<li>[[Sir2000 User Language Tools]]</li> | |||
<li> | |||
</ul> | </ul> | ||
<p class="caption">Products authorizing $Sir_ND2Date | <p class="caption">Products authorizing $Sir_ND2Date | ||
</p> | </p> | ||
[[Category:$Functions|$Sir_ND2Date]] | [[Category:$Functions|$Sir_ND2Date]] |
Revision as of 19:31, 8 February 2011
<section begin="desc" />Convert datetime number of days to string<section end="desc" />
Most Sirius $functions have been deprecated in favor of Object Oriented methods. There is currently no OO equivalent for the $Sir_ND2Date function.
The $Sir_ND2Date function expects a numeric datetime argument containing a number of days since January 1, 1900, and a datetime format string. It returns the date represented by the first argument, in the format corresponding to the second argument. $Sir_ND2Date accepts an optional error control string and returns the null string if an error is detected.
Syntax
<section begin="syntax" /> %dat = $Sir_ND2Date(datn, fmt, errctl) <section end="syntax" />
where
datn | datetime number containing a signed number of days since January 1, 1900. |
---|---|
fmt | datetime format string. Refer to for an explanation of valid datetime formats and valid datetime values. |
errctl | optional error control string, refer to . |
%dat | set to the datetime value string, using format specified by fmt, corresponding to datn, unless an error is detected. |
For example, the following fragment prints the string 07/31/84:
%X = $Sir_Date2ND('8407301230', 'YYMMDDHHMI') * Add a day: %X = %X + 1 PRINT $Sir_ND2Date(%X, 'MM/DD/YY')
Error conditions are shown in the following figure.
- fmt is not a valid datetime format.
- datn out of range.
Notes: The inverse of this $function is $Sir_Date2ND.