$Sir DateN: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
m (link repair) |
||
(14 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> | <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. | ||
==Syntax== | ==Syntax== | ||
<p class="syntax">%num = $Sir_DateN | <p class="syntax"><span class="term">%num</span> = $Sir_DateN | ||
</p> | </p> | ||
===Syntax terms=== | ===Syntax terms=== | ||
<table | <table> | ||
<tr><th>%num</th> | <tr><th>%num</th> | ||
<td> | <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>[[Janus Open Client]]</li> | <li>[[Media:JoclrNew.pdf|Janus Open Client]]</li> | ||
<li>[[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> | <li>Japanese functions</li> | ||
<li>[[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')