in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Powerhouse Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    NetBotz History Export date is seen as a Linux Time Stamp

    Issue:

    NetBotz History Export date is seen as a Linux Time Stamp.

    Product Line:

    NetBotz

    Environment:

    NetBotz History Export.

    Cause:

    NetBotz is based on the Linux operating system and as such much of it's data uses a Linux Time Stamp The Exported data may look something like this:
    "Sensor Pod (integrated)";"Temperature";"1465097276057";"30.00"

    Resolution:

    It is unlikely this will be changed in a future revision so if it is necessary to view this as a date, the information can always be imported into a spread sheet application such as Microsoft Excel.

    I can translate 1465097276057 on the epochtime.com page but in Microsoft Excel, the number does not translate easily. I must delete the last 3 digits just to be able to use the suggested Excel formulae:
    =(((C2/60)/60)/24)+DATE(1970,1,1)

    or
    =C2/(60*60*24)+"1/1/1970"

    You can also cut off the rest of the numbers by using a formula like this:
    =(((LEFT(C2,10)/60)/60)/24)+DATE(1970,1,1)
    When formatted properly using a time format, the result should look like this:
    6/5/16 3:27 AM
     

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance