$Sir DateNS: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
mNo edit summary
Line 8: Line 8:
==Syntax==
==Syntax==
<p class="syntax">%num = $Sir_DateNS
<p class="syntax">%num = $Sir_DateNS
</p>
<p>
</p>
</p>


where
===Syntax terms===
 
<table class="syntaxTable">
<table class="syntaxTable">
<tr><th>%num</th>
<tr><th>%num</th>
Line 20: Line 17:
</table>
</table>


For example, the following fragment will print the date and time 1 minute from the current time:
==Usage notes==
<p class="code"> PRINT $Sir_NS2Date($Sir_DateNS + 60, 'MM/DD/YY HH:MI:SS')
<ul>
</p>
<li><var>$Sir_DateNS</var> has no error conditions.


<var>$Sir_DateNS</var> has no error conditions.  
<li>Values returned by <var>$Sir_DateNS</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.  


Notes:
<ul>
<li>Values returned by <var>$Sir_DateNS</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>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>To convert the number of seconds to a readable form, use <var>$Sir_NS2Date</var>.
<li>To convert the number of seconds to a readable form, use <var>$Sir_NS2Date</var>.
</ul>
</ul>
==Example==
The following fragment will print the date and time 1 minute from the current time:
<p class="code">PRINT $Sir_NS2Date($Sir_DateNS + 60, 'MM/DD/YY HH:MI:SS')
</p>


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

Revision as of 21:51, 19 July 2013

Current date and time as number of seconds

Note: Most Sirius $functions have been deprecated in favor of Object Oriented methods. The OO equivalent of $Sir_DateNS is CurrentTimeSeconds.

The $Sir_DateNS function has no arguments and returns the number of seconds since 1 January, 1900.

Syntax

%num = $Sir_DateNS

Syntax terms

%num set to the number of seconds from 1 Jan 1900 12:00 AM to the current date and time.

Usage notes

  • $Sir_DateNS has no error conditions.
  • Values returned by $Sir_DateNS 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 the number of seconds to a readable form, use $Sir_NS2Date.

Example

The following fragment will print the date and time 1 minute from the current time:

PRINT $Sir_NS2Date($Sir_DateNS + 60, 'MM/DD/YY HH:MI:SS')

Products authorizing $Sir_DateNS