Can't figure out what this value represents...

[Geates]

I have some code that returns the a date of the last SCCM heartbeat on a machine. It contains a value that I can not decypher. I was hoping someone might be able to tell me what it is. What is [red]157258080[/red]?

sys_data.lastlogon0 is the number of nanoseconds since Jan, 1, 1900 (I think)

dateadd(n, (sys_data.lastlogon0/600000000) - [red][b]157258080[/b][/red], 0) as 'last heartbeat'

-Geates

http://ns7.webmasters.com/caspdoc/html/vbscript_language_reference.htm

 

[Geates]

sys_data.lastlogon0 is the number of nanoseconds since Jan, 1, 1900 (I think)

...merely coincidence.

157258080 represents the "base date" offset in minutes from 1.1.1601 to 1.1.1900 because .lastlogon0 is a int8 data type.

http://myitforum.com/cs2/blogs/jnelson/archive/2009/08/25/140938.aspx

-Geates

http://ns7.webmasters.com/caspdoc/html/vbscript_language_reference.htm