$Sir Date2N - Revision history

JAL: link repair

2018-02-08T22:52:05Z

link repair

← Older revision		Revision as of 22:52, 8 February 2018
Line 65:		Line 65:
	<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_Date2N]]		[[Category:$Functions\|$Sir_Date2N]]

JAL: add link

2015-09-24T18:52:51Z

add link

← Older revision		Revision as of 18:52, 24 September 2015
Line 2:		Line 2:
	<span class="pageSubtitle">Convert datetime string to number of seconds/300</span>		<span class="pageSubtitle">Convert datetime string to number of seconds/300</span>

	<p class="warn"><b>Note: </b>Many $functions have been deprecated in favor of Object Oriented methods. There is currently no OO equivalent for the $Sir_Date2N function.</p>		<p class="warn"><b>Note: </b>Many $functions have been deprecated in favor of [[:Category:SOUL object-oriented programming topics\|SOUL Object Oriented]] methods. There is currently no OO equivalent for the $Sir_Date2N function.</p>

	The <var>$Sir_Date2N</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of 1/300th seconds since 1 January, 1900. It accepts an optional <var>[[Datetime string formats#.24Sir_Datexxx CENTSPAN argument\|CENTSPAN]]<var> value and an optional error control string. If an error is detected, the returned value is <code>-9E12</code> (-9000000000000).		The <var>$Sir_Date2N</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of 1/300th seconds since 1 January, 1900. It accepts an optional <var>[[Datetime string formats#.24Sir_Datexxx CENTSPAN argument\|CENTSPAN]]</var> value and an optional error control string. If an error is detected, the returned value is <code>-9E12</code> (-9000000000000).

	==Syntax==		==Syntax==
	<p class="syntax"><span class="term">%num</span> <span class="literal">= $Sir_Date2N(</span><span class="term">dat</span><span class="literal">,</span> <span class="term">fmt</span><span class="literal">,</span> <span class="term">span</span><span class="literal">,</span> <span class="term">errctl</span><span class="literal">)</span>		<p class="syntax"><span class="term">%num</span> <span class="literal">= $Sir_Date2N(</span><span class="term">dat</span><span class="literal">,</span> <span class="term">fmt</span><span class="literal">,</span> [<span class="term">span</span>]<span class="literal">,</span> [<span class="term">errctl</span>]<span class="literal">)</span>
	</p>		</p>

JAL: typo

2015-09-24T18:17:01Z

typo

← Older revision		Revision as of 18:17, 24 September 2015
Line 2:		Line 2:
	<span class="pageSubtitle">Convert datetime string to number of seconds/300</span>		<span class="pageSubtitle">Convert datetime string to number of seconds/300</span>

	<p class="warn"><b>Note: </b>~~Most Sirius~~ $functions have been deprecated in favor of Object Oriented methods. There is ~~currentyly~~ no OO equivalent for the $Sir_Date2N function.</p>		<p class="warn"><b>Note: </b>Many $functions have been deprecated in favor of Object Oriented methods. There is currently no OO equivalent for the $Sir_Date2N function.</p>

	The <var>$Sir_Date2N</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of 1/300th seconds since 1 January, 1900. It accepts an optional <var>[[Datetime string formats#.24Sir_Datexxx CENTSPAN argument\|CENTSPAN]]<var> value and an optional error control string. If an error is detected, the returned value is <code>-9E12</code> (-9000000000000).		The <var>$Sir_Date2N</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of 1/300th seconds since 1 January, 1900. It accepts an optional <var>[[Datetime string formats#.24Sir_Datexxx CENTSPAN argument\|CENTSPAN]]<var> value and an optional error control string. If an error is detected, the returned value is <code>-9E12</code> (-9000000000000).

JAL: add link

2015-09-24T18:15:23Z

add link

← Older revision		Revision as of 18:15, 24 September 2015
Line 4:		Line 4:
	<p class="warn"><b>Note: </b>Most Sirius $functions have been deprecated in favor of Object Oriented methods. There is currentyly no OO equivalent for the $Sir_Date2N function.</p>		<p class="warn"><b>Note: </b>Most Sirius $functions have been deprecated in favor of Object Oriented methods. There is currentyly no OO equivalent for the $Sir_Date2N function.</p>

	The <var>$Sir_Date2N</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of 1/300th seconds 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 -9E12 (-9000000000000).		The <var>$Sir_Date2N</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of 1/300th seconds since 1 January, 1900. It accepts an optional <var>[[Datetime string formats#.24Sir_Datexxx CENTSPAN argument\|CENTSPAN]]<var> value and an optional error control string. If an error is detected, the returned value is <code>-9E12</code> (-9000000000000).

	==Syntax==		==Syntax==
Line 15:		Line 15:
	<td>Set to the value of <var class="term">dat</var>, converted to the number of 1/300th second units from 1 Jan 1900 12:00 AM.		<td>Set to the value of <var class="term">dat</var>, converted to the number of 1/300th second units from 1 Jan 1900 12:00 AM.
	</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 CENTSPAN value; default is -50. </td></tr>		<td>Optional <var>[[Datetime string formats#.24Sir_Datexxx CENTSPAN argument\|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_Date2N</var> often exceed the range that can be represented in a 4-byte integer, so you should probably avoid storing the value in a <var>BINARY</var> or <var>FLOAT4</var> field.		<li>Values returned by <var>$Sir_Date2N</var> often exceed the range that can be represented in a 4-byte integer, so you should probably avoid storing the value in a <var>BINARY</var> or <var>FLOAT4</var> field. </li>
	<li>Dates prior to 1 January 1900 return a negative number.
	<li>The inverse of this $function is <var>[[$Sir_N2Date]]</var>.		<li>Dates prior to 1 January 1900 return a negative number. </li>
	<li><var>$Sir_Date2N</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_N2Date]]</var>. </li>

			<li><var>$Sir_Date2N</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>
Line 37:		Line 44:
	<li><var class="term">dat</var> is outside of range permitted for <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">span</var> is invalid.		<li><var class="term">span</var> is invalid.
	</ul>		</ul></li>
	</ul>		</ul>

Line 58:		Line 65:
	<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>[~~http~~:~~//m204wiki.rocketsoftware.com/images/d/d6/~~Ul2krNew.pdf Sir2000 User Language Tools]</li>		<li>[[Media:Ul2krNew.pdf\|Sir2000 User Language Tools]]</li>
	</ul>		</ul>


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

JALWiccan: Automatically generated page update

2015-02-19T23:09:50Z