$Sir Date2NS - Revision history

JAL: misc cleanup

2015-10-06T21:51:33Z

misc cleanup

← Older revision		Revision as of 21:51, 6 October 2015
Line 2:		Line 2:
	<span class="pageSubtitle">Convert datetime string to number of seconds</span>		<span class="pageSubtitle">Convert datetime string to number of seconds</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_Date2NS function is <var>[[StringToSeconds (String function)\|StringToSeconds]]</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_Date2NS function is <var>[[StringToSeconds (String function)\|StringToSeconds]]</var>.</p>

	The <var>$Sir_Date2NS</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of seconds since 1 January, 1900. It accepts an optional <var>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_Date2NS</var> function expects a datetime value string and a datetime format string and returns the input datetime converted to the number of seconds since 1 January, 1900. It accepts an optional <var>CENTSPAN</var> 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 seconds from 1 Jan 1900 12:00 AM.		<td>Set to the value of <var class="term">dat</var>, converted to the number of seconds 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_Date2NS</var> will 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_Date2NS</var> will 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_NS2Date]]</var>.		<li>Dates prior to 1 January 1900 return a negative number.</li>
	<li>$Sir_Date2NS 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_NS2Date]]</var>.</li>

			<li><var>$Sir_Date2NS</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 46:		Line 56:
	Print %c		Print %c
	</p>		</p>


	==Products authorizing {{PAGENAMEE}}==		==Products authorizing {{PAGENAMEE}}==

JALWiccan: Automatically generated page update

2015-02-19T23:09:51Z

Automatically generated page update

← Older revision		Revision as of 23:09, 19 February 2015
Line 57:		Line 57:
	<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>[http://m204wiki.rocketsoftware.com/images/d/d6/Ul2krNew.pdf Sir2000 User Language Tools]		<li>[http://m204wiki.rocketsoftware.com/images/d/d6/Ul2krNew.pdf Sir2000 User Language Tools]

JALWiccan: Automatically generated page update

2015-02-19T22:58:45Z

Automatically generated page update

← Older revision		Revision as of 22:58, 19 February 2015
Line 57:		Line 57:
	<li>[[Janus Web Server]]</li>		<li>[[Janus Web Server]]</li>
	<li>Japanese functions</li>		<li>Japanese functions</li>
	<li>[~~http~~:~~//m204wiki.rocketsoftware.com/images/4/4b/~~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>[http://m204wiki.rocketsoftware.com/images/d/d6/Ul2krNew.pdf Sir2000 User Language Tools]

JALWiccan: Automatically generated page update

2015-02-19T22:38:44Z

Automatically generated page update

← Older revision		Revision as of 22:38, 19 February 2015
Line 53:		Line 53:
	<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>

JALWiccan: Automatically generated page update

2015-02-19T22:35:17Z

Automatically generated page update

← Older revision		Revision as of 22:35, 19 February 2015
Line 53:		Line 53:
	<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>[~~http~~:~~//m204wiki.rocketsoftware.com/images/1/17/~~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>

JALWiccan: Automatically generated page update

2015-02-19T21:21:42Z

Automatically generated page update

← Older revision		Revision as of 21:21, 19 February 2015
Line 52:		Line 52:
	<li>[[List of $functions\|Sirius functions]]</li>		<li>[[List of $functions\|Sirius functions]]</li>
	<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>[http://m204wiki.rocketsoftware.com/images/1/17/JosrvrNew.pdf Janus Open Server]</li>		<li>[http://m204wiki.rocketsoftware.com/images/1/17/JosrvrNew.pdf Janus Open Server]</li>
	<li>[[Janus Sockets]]</li>		<li>[[Janus Sockets]]</li>

JALWiccan: Automatically generated page update

2015-02-19T21:18:03Z

Automatically generated page update

← Older revision		Revision as of 21:18, 19 February 2015
Line 52:		Line 52:
	<li>[[List of $functions\|Sirius functions]]</li>		<li>[[List of $functions\|Sirius functions]]</li>
	<li>[[Fast/Unload User Language Interface]]</li>		<li>[[Fast/Unload User Language Interface]]</li>
	<li>[~~http~~:~~//m204wiki.rocketsoftware.com/images/4/4a/~~JoclrNew.pdf Janus Open Client]</li>		<li>[[Media:JoclrNew.pdf\|Janus Open Client]</li>
	<li>[http://m204wiki.rocketsoftware.com/images/1/17/JosrvrNew.pdf Janus Open Server]</li>		<li>[http://m204wiki.rocketsoftware.com/images/1/17/JosrvrNew.pdf Janus Open Server]</li>
	<li>[[Janus Sockets]]</li>		<li>[[Janus Sockets]]</li>

JALWiccan: Automatically generated page update

2014-08-01T22:08:27Z

Automatically generated page update

← Older revision		Revision as of 22:08, 1 August 2014
Line 50:		Line 50:
	==Products authorizing {{PAGENAMEE}}==		==Products authorizing {{PAGENAMEE}}==
	<ul class="smallAndTightList">		<ul class="smallAndTightList">
	<li>[[Sirius functions]]</li>		<li>[[List of $functions\|Sirius functions]]</li>
	<li>[[Fast/Unload User Language Interface]]</li>		<li>[[Fast/Unload User Language Interface]]</li>
	<li>[http://m204wiki.rocketsoftware.com/images/4/4a/JoclrNew.pdf Janus Open Client]</li>		<li>[http://m204wiki.rocketsoftware.com/images/4/4a/JoclrNew.pdf Janus Open Client]</li>

JAL: /* Products authorizing {{PAGENAMEE}} */

2014-07-14T20:08:48Z

Products authorizing {{PAGENAMEE}}

← Older revision		Revision as of 20:08, 14 July 2014
Line 59:		Line 59:
	<li>[http://m204wiki.rocketsoftware.com/images/4/4b/SirfieldNew.pdf Sir2000 Field Migration Facility]</li>		<li>[http://m204wiki.rocketsoftware.com/images/4/4b/SirfieldNew.pdf Sir2000 Field Migration Facility]</li>

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

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

JALWiccan: Automatically generated page update

2014-07-14T20:06:47Z

Automatically generated page update

← Older revision		Revision as of 20:06, 14 July 2014
Line 59:		Line 59:
	<li>[http://m204wiki.rocketsoftware.com/images/4/4b/SirfieldNew.pdf Sir2000 Field Migration Facility]</li>		<li>[http://m204wiki.rocketsoftware.com/images/4/4b/SirfieldNew.pdf Sir2000 Field Migration Facility]</li>

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

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