Importing efu/csv with different Date format

[InfoR3aper]

So I have a lot of json exports where the date string is

1675472697

But EFU date length is like this

133278337075219626

I tried padding my dates with 8 zeros but that does not work either.

So does Everything have a way to import say csv or ability inside Everything to change the date string/format?

Basically my exports are a list of URLS with the date last modified, but the date format does not follow the format Everything is using so it makes it impossible inside everything to see the proper date.

[NotNull]

That date format -- Unix epoch time -- is not supported by EFU filelists.


You will have to convert this to a format Everything understands (see below) or export in a different format

Unix epoch time is the number of seconds since 1970-01-01 00:00
Windows filetime is the number of 100-nanoseconds since 1601-01-01 00:00

efu_filetime

The EFU filelist filetime format

Can be one of the following values:

0 = FILETIME as Decimal. (default)
1 = ISO 8601 (converted to UTC).
2 = ISO 8601 (with time zone offset).

[void]

Code: Select all

#define WINDOWS_TICK 10000000
#define SEC_TO_UNIX_EPOCH 11644473600LL

long long UnixSecondsToWindowsTick(unsigned unixSeconds)
{
     return (((long long)unixSeconds) + SEC_TO_UNIX_EPOCH) * WINDOWS_TICK;
}

Convert Windows Filetime to second in Unix/Linux