What time format is used in efu-files?

General discussion related to "Everything".
Post Reply
zeus04
Posts: 16
Joined: Wed Oct 17, 2018 3:45 pm

What time format is used in efu-files?

Post by zeus04 »

Looking at the timestamps in efu-files. Can't decide what to make of it.
I have a 18 digit number:
131 339 439 831 094 815
the date and time from app is:
14/03/2017 06:46
From what i have tried it does not correspond to UNIX epoch time or C#'s DateTime ticks.

Can anyone shed some light on this?
void
Developer
Posts: 16680
Joined: Fri Oct 16, 2009 11:31 pm

Re: What time format is used in efu-files?

Post by void »

EFU files use the Windows FILETIME format in decimal.
EFU files also support ISO 8601 dates.
However, when saving from Everything, EFU files always use FILETIMEs for performance reasons.

FILETIME
Contains a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (UTC).

https://docs.microsoft.com/en-us/windows/win32/api/minwinbase/ns-minwinbase-filetime

What is the format of an EFU file list?

Convert FILETIME To Unix time:
https://stackoverflow.com/questions/6161776/convert-windows-filetime-to-second-in-unix-linux
mczerski
Posts: 57
Joined: Mon Aug 23, 2021 3:07 pm

Re: What time format is used in efu-files?

Post by mczerski »

Hi, I would use your advice:
Convert FILETIME To Unix time:
https://stackoverflow.com/questions/616 ... unix-linux
if only it would be useful for me. But it is not. I am not skilful in C+ (referred to on the site advised by you), and – first of all – I need to use EFU file in MSAccess (VBA/SQL), in which I am quite skilful. The number of digits in UTF date exceeds the limitations imposed by Microsoft on MSAccess operations. Are there any freeware converters or VBA/SQL procedures to convert your UTF data format to standard formats or Unix datetime format?
Your advice will be greatly appreciated.
void
Developer
Posts: 16680
Joined: Fri Oct 16, 2009 11:31 pm

Re: What time format is used in efu-files?

Post by void »

I'll look into making a script or tool to convert the EFU filetime format.

For now, there will be a switch in the next Everything version to save the time as ISO 8601 (UTC) or ISO 8601 (with timezone)
If you would like to try this now, please check out the Everything 1.5 alpha.

To change the efu filetime format:
  • In Everything 1.5, type in the following search and press ENTER:
    /efu_filetime=x
    where x can be one of the following:
    • 0 = FILETIME as decimal.
    • 1 = ISO 8601 (converted to UTC).
    • 2 = ISO 8601 (with time zone offset).
  • If successful, you should see efu_filetime=x in the status bar for a few seconds.


efu_filetime
Post Reply