$Sir DateN: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
m (link repair)
 
(9 intermediate revisions by 2 users not shown)
Line 2: Line 2:
<span class="pageSubtitle">Current date and time as number of seconds/300</span>
<span class="pageSubtitle">Current date and time as 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 currently no OO equivalent for the $Sir_DateN 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_DateN function.</p>


The <var>$Sir_DateN</var> function has no arguments and returns the number of 1/300 second units since 1 January, 1900.
The <var>$Sir_DateN</var> function has no arguments and returns the number of 1/300 second units since 1 January, 1900.
Line 11: Line 11:


===Syntax terms===
===Syntax terms===
<table class="syntaxTable">
<table>
<tr><th>%num</th>
<tr><th>%num</th>
<td>set to the number of 1/300th seconds units from 1 Jan 1900 12:00 AM to the current date and time.
<td>Set to the number of 1/300th seconds units from <code>1 Jan 1900 12:00 AM</code> to the current date and time.
</td></tr></table>
</td></tr>
</table>


==Usage notes==
==Usage notes==
<ul>
<ul>
<li><var>$Sir_DateN</var> has no error conditions.  
<li><var>$Sir_DateN</var> has no error conditions. </li>


<li>Values returned by <var>$Sir_DateN</var> will exceed the range that can be represented in a 4-byte integer, so you should probably avoid storing the value in a BINARY or FLOAT4 field.  
<li>Values returned by <var>$Sir_DateN</var> will 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>To obtain the current date and time in a readable form, use <var>$Sir_Date</var>.  
<li>To obtain the current date and time in a readable form, use <var>$Sir_Date</var>. </li>


<li>To convert a datetime number to a readable form, use <var>$Sir_N2Date</var>.
<li>To convert a datetime number to a readable form, use <var>$Sir_N2Date</var>.</li>
</ul>
</ul>


Line 34: Line 35:
==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>[[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>
<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>[[Sir2000 User Language Tools]]</li>
<li>[[Sir2000 User Language Tools]]</li>
</ul>
</ul>


[[Category:$Functions|$Sir_DateN]]
[[Category:$Functions|$Sir_DateN]]

Latest revision as of 22:50, 8 February 2018

Current date and time as number of seconds/300

Note: Many $functions have been deprecated in favor of Object Oriented methods. There is currently no OO equivalent for the $Sir_DateN function.

The $Sir_DateN function has no arguments and returns the number of 1/300 second units since 1 January, 1900.

Syntax

%num = $Sir_DateN

Syntax terms

%num Set to the number of 1/300th seconds units from 1 Jan 1900 12:00 AM to the current date and time.

Usage notes

  • $Sir_DateN has no error conditions.
  • Values returned by $Sir_DateN will exceed the range that can be represented in a 4-byte integer, so you should probably avoid storing the value in a BINARY or FLOAT4 field.
  • To obtain the current date and time in a readable form, use $Sir_Date.
  • To convert a datetime number to a readable form, use $Sir_N2Date.

Example

The following fragment will print the date and time 1.5 seconds from the current time:

PRINT $Sir_N2Date($Sir_DateN + 450, 'MM/DD/YY HH:MI:SS.XX')

Products authorizing $Sir_DateN