Longit Woes...

[jenkinsp]

I am trying to pull out "accountexpires" info from MS Active directory, but MS have made this field LARGE INT or INTEGER8, and cant work out how to convert this to something "Normal" The actual number is a standard UNIX date/time.

The raw number I get from AD is: 127093968000000000

Eventually this should end up as 30 september 2003.

HELP!

[DeltaRho2K]

There are too many digits in your number to equal that of the date you have...

The standard Unix timestamp for 00:00:00 9-30-2003 is actually:
1064894400

When I plugged your number (127093968000000000) into the date() function, I get the following hh:mm:ss mm-dd-yyyy results:
15:48:00 11-23-2020

Are you sure MS Active Directory stores this in a Unix Timestamp? I am not being facetious... I am just not sure myself, but I am sure that the number it has stored doesn't give you the date you want using the date() function...

[DeltaRho2K]

Wait, I just reread your post, and I see what you mean now...
I wonder if AD converts the number to Hex number (only it doesn't display the 0x on it from AD... Microsoft is notorious for converting their integer strings into Hex... Let me play around with it... No guarantees though...

You may want to look at the manual for intval()