Difference between revisions of "Manuals/calci/NOW"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''NOW()'''</div><br/> |
| + | **NOW(), returns the serial number of the current date and time. | ||
| − | + | == Description == | |
| − | + | NOW() | |
| − | |||
| − | |||
| − | + | *Dates are stored in the form of sequential numbers so that they can be used in calculations. e.g. January 1, 1900 is stored as serial number 1 and so on. | |
| + | *Numbers to the left of decimal point represent serial number of current date. | ||
| + | *Numbers to the right of decimal point represent serial number of current time. | ||
| + | *This function does not have any arguments. | ||
| + | *TODAY() function can be used to display the serial number of today's date only. | ||
| − | + | == Examples == | |
| − | + | 1) The NOW() function displays the ouput in ZOS as follows - | |
| − | |||
| − | - | ||
| − | |||
| − | < | + | <div id="6SpaceContent" class="zcontent" align="left"> |
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| − | -- | + | |- class="even" |
| − | + | | class=" " | '''Function''' | |
| + | | class=" " | '''Output''' | ||
| + | |||
| + | |- class="odd" | ||
| + | | class="sshl_f" |NOW() | ||
| + | | class="sshl_f" |41724.771261574075 | ||
| + | |||
| + | |- class="even" | ||
| + | | class="sshl_f" | | ||
| + | | class="sshl_f" | | ||
| + | |} | ||
| + | |||
| + | 2) The NOW() function displays the output in Calci as follows - | ||
| + | |||
| + | =NOW() : Returns the result as '''Wed Mar 26 2014 19:28:19 GMT-0400 (Eastern Daylight Time)''' | ||
| + | |||
| + | |||
| + | ==Related Videos== | ||
| − | + | {{#ev:youtube|v=pTsu5Gyxl8A|280|center|Now}} | |
| − | + | == See Also == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Manuals/calci/DATE | DATE]] | |
| + | *[[Manuals/calci/TIME | TIME]] | ||
| + | *[[Manuals/calci/TODAY | TODAY]] | ||
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Wikipedia:Manual_of_Style/Dates_and_numbers#Date_formats Date Formats] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Z_API_Functions | List of Main Z Functions]] | |
| − | + | *[[ Z3 | Z3 home ]] | |
| − | |||
Latest revision as of 12:38, 25 March 2019
NOW()
- NOW(), returns the serial number of the current date and time.
Description
NOW()
- Dates are stored in the form of sequential numbers so that they can be used in calculations. e.g. January 1, 1900 is stored as serial number 1 and so on.
- Numbers to the left of decimal point represent serial number of current date.
- Numbers to the right of decimal point represent serial number of current time.
- This function does not have any arguments.
- TODAY() function can be used to display the serial number of today's date only.
Examples
1) The NOW() function displays the ouput in ZOS as follows -
| Function | Output |
| NOW() | 41724.771261574075 |
2) The NOW() function displays the output in Calci as follows -
=NOW() : Returns the result as Wed Mar 26 2014 19:28:19 GMT-0400 (Eastern Daylight Time)
Related Videos
See Also
References