Is there a way to convert a ProvideX TIM / TME based value to seconds? The JUL() function only works with dates.
This is how ScriptBasic's TIMEVALUE works.
Is there a way to convert a ProvideX TIM / TME based value to seconds? The JUL() function only works with dates.
This is how ScriptBasic's TIMEVALUE works.
Thank You!
I tried DTE() but failed to use the %S mask. I'm curious why it has to be a string to receive the numeric seconds results.
*WISH* - Use the ScriptBasic TIMEVALUE C code to enhance ProvideX's JUL() function.
I'm trying to get the number of seconds since 1/1/1970. The ProvideX JUL() function returns days since that that date. If I multiply it by the seconds in a day (86,400) the returned value isn't correct.
->print JUL(2021,10,7)
2459495
->print JUL(2021,10,7) * 86400
212500368000
->
The correct value should be 1633564800
ProvideX should be returning 18907 for the number of days using my date example.
->print 18907 * 86400
1633564800
->
The 'BY' value = 0
I started the Sage ProvideX session by clicking on pvxwin32.exe in the Windows Explorer.
The JUL( ) function is used to convert a date from year, month, day to a Julian date. The Julian date is an integer: the number of days since the system base date. By default, this is January 1, 1970. Use the 'BY' system parameter to change the base date.
RESOLVED
->SET_PARAM 'BY'=1970
->PRINT JUL(2021,10,7)
18907
->
*Community Hub is the new name for Sage City