$Sir Date2ND - Revision history

JAL: link repair

2018-02-08T22:52:55Z

link repair

← Older revision		Revision as of 22:52, 8 February 2018
Line 61:		Line 61:

	<li>[[Fast/Unload User Language Interface]]</li>		<li>[[Fast/Unload User Language Interface]]</li>

	<li>[[Media:JoclrNew.pdf\|Janus Open Client]]</li>		<li>[[Media:JoclrNew.pdf\|Janus Open Client]]</li>

	<li>[[Media:JosrvrNew.pdf\|Janus Open Server]]</li>		<li>[[Media:JosrvrNew.pdf\|Janus Open Server]]</li>

	<li>[[Janus Sockets]]</li>		<li>[[Janus Sockets]]</li>

	<li>[[Janus Web Server]]</li>		<li>[[Janus Web Server]]</li>

	<li>Japanese functions</li>		<li>Japanese functions</li>

	<li>[[Media:SirfieldNew.pdf\|Sir2000 Field Migration Facility]]</li>		<li>[[Media:SirfieldNew.pdf\|Sir2000 Field Migration Facility]]</li>

	<li>[[~~Media:Ul2krNew.pdf\|~~Sir2000 User Language Tools]]</li>		<li>[[Sir2000 User Language Tools]]</li>
	</ul>		</ul>


	[[Category:$Functions\|$Sir_Date2ND]]		[[Category:$Functions\|$Sir_Date2ND]]

JAL: minor formatting

2015-10-06T21:37:39Z

minor formatting

← Older revision		Revision as of 21:37, 6 October 2015
Line 2:		Line 2:
	<span class="pageSubtitle">Convert datetime string to number of days</span>		<span class="pageSubtitle">Convert datetime string to number of days</span>

	<p class="warn"><b>Note: </b>~~Most Sirius~~ $functions have been deprecated in favor of Object Oriented methods. The OO equivalent for the $Sir_Date2ND function is <var>[[StringToDays (String function)\|StringToDays]]</var>.</p>		<p class="warn"><b>Note: </b>Many $functions have been deprecated in favor of Object Oriented methods. The OO equivalent for the $Sir_Date2ND function is <var>[[StringToDays (String function)\|StringToDays]]</var>.</p>

	The <var>$Sir_Date2ND</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of days since 1 January, 1900. It accepts an optional CENTSPAN value and an optional error control string. If an error is detected, the returned value is <code>-9E12</code> (-9000000000000).		The <var>$Sir_Date2ND</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of days since 1 January, 1900. It accepts an optional CENTSPAN value and an optional error control string. If an error is detected, the returned value is <code>-9E12</code> (-9000000000000).
Line 11:		Line 11:

	===Syntax terms===		===Syntax terms===
	<table ~~class="syntaxTable"~~>		<table>
	<tr><th>%num</th>		<tr><th>%num</th>
	<td>Set to the value of <var class="term">dat</var>, converted to the number of days from 1 Jan 1900 12:00 AM.		<td>Set to the value of <var class="term">dat</var>, converted to the number of days from <code>1 Jan 1900 12:00 AM</code>.
	</td></tr>		</td></tr>

	<tr><th>dat</th>		<tr><th>dat</th>
	<td>Datetime value string.</td></tr>		<td>Datetime value string.</td></tr>

	<tr><th>fmt</th>		<tr><th>fmt</th>
	<td>Datetime format string corresponding to <var class="term">dat</var>. Refer to [[Datetime string formats~~\|"Datetime string formats"~~]] for an explanation of valid datetime formats and valid dates. Non-strict matching is used for input format <var class="term">fmt</var>; see [[Datetime string formats#Strict and non-strict format matching\|"Strict and non-strict format matching"]].</td></tr>		<td>Datetime format string corresponding to <var class="term">dat</var>. Refer to [[Datetime string formats]] for an explanation of valid datetime formats and valid dates. Non-strict matching is used for input format <var class="term">fmt</var>; see [[Datetime string formats#Strict and non-strict format matching\|Strict and non-strict format matching]].</td></tr>

	<tr><th>span</th>		<tr><th>span</th>
	<td>Optional <var>CENTSPAN</var> value, default is -50. </td></tr>		<td>Optional <var>CENTSPAN</var> value, default is -50. </td></tr>
	<tr><th>errctl</th>		<tr><th>errctl</th>
	<td>Optional error control string; refer to [[Datetime string formats#Datetime error handling\|"Datetime error handling"]].</td></tr>		<td>Optional error control string; refer to [[Datetime string formats#Datetime error handling\|Datetime error handling]].</td></tr>
	</table>		</table>

	==Usage notes==		==Usage notes==
	<ul>		<ul>
	<li>Values returned by <var>$Sir_Date2ND</var> can be stored in a <var>BINARY</var> or <var>FLOAT4</var> field, if you want.		<li>Values returned by <var>$Sir_Date2ND</var> can be stored in a <var>BINARY</var> or <var>FLOAT4</var> field, if you want.</li>
	<li>Dates prior to 1 January 1900 will return a negative number.
	<li>The inverse of this $function is <var>[[$Sir_ND2Date]]</var>.		<li>Dates prior to 1 January 1900 will return a negative number. </li>
	<li><var>$Sir_Date2ND</var> returns the value <code>-9E12</code> (-9000000000000) in the following cases (see the discussion in [[Datetime string formats#Datetime error handling\|"Datetime error handling"]]):
			<li>The inverse of this $function is <var>[[$Sir_ND2Date]]</var>.</li>

			<li><var>$Sir_Date2ND</var> returns the value <code>-9E12</code> (-9000000000000) in the following cases (see the discussion in [[Datetime string formats#Datetime error handling\|Datetime error handling]]):
	<ul>		<ul>
	<li><var class="term">fmt</var> is not a valid datetime format.		<li><var class="term">fmt</var> is not a valid datetime format.</li>
	<li><var class="term">dat</var> does not match <var class="term">fmt</var>.
	<li><var class="term">dat</var> is outside of range permitted for <var class="term">fmt</var>.		<li><var class="term">dat</var> does not match <var class="term">fmt</var>.</li>
	<li><var class="term">span</var> is invalid.
	</ul>		<li><var class="term">dat</var> is outside of range permitted for <var class="term">fmt</var>.</li>

			<li><var class="term">span</var> is invalid.</li>
			</ul></li>
	</ul>		</ul>

Line 60:		Line 69:
	<li>[[Media:SirfieldNew.pdf\|Sir2000 Field Migration Facility]]</li>		<li>[[Media:SirfieldNew.pdf\|Sir2000 Field Migration Facility]]</li>

	<li>[~~http~~:~~//m204wiki.rocketsoftware.com/images/d/d6/~~Ul2krNew.pdf Sir2000 User Language Tools]		<li>[[Media:Ul2krNew.pdf\|Sir2000 User Language Tools]]</li>
	</ul>		</ul>


	[[Category:$Functions\|$Sir_Date2ND]]		[[Category:$Functions\|$Sir_Date2ND]]

JALWiccan: Automatically generated page update

2015-02-19T23:09:51Z