1. Forum
  2. Usenet
  3. COMP.DATABASES.FILEMAKER

  • Timestamp starting 1970

    From Christoph Kaufmann@21:1/5 to All on Wed Feb 1 20:43:00 2023
    I reveived a sample csv file from some web form (not iwp) with a field "CreationDate" with the value 1675255462 in it.

    I assume its the same sort of timestamp filemaker uses, but starting at 01/01/1970 rather than 01/01/0001 like Filemaker does - that makes it
    Feb 1st, 2023, 12h44, which is a plausible creation time or this sample.

    Are there databases using timestamps as seconds after 1st January, 1970,
    00h00?
    --
    TIA
    Christoph Kaufmann
    https://clk.ch

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From kurtz le pirate@21:1/5 to Christoph Kaufmann on Fri Nov 17 15:49:09 2023
    On 01/02/2023 20:43, Christoph Kaufmann wrote:
    I reveived a sample csv file from some web form (not iwp) with a field "CreationDate" with the value 1675255462 in it.

    I assume its the same sort of timestamp filemaker uses, but starting at 01/01/1970 rather than 01/01/0001 like Filemaker does - that makes it
    Feb 1st, 2023, 12h44, which is a plausible creation time or this sample.

    Yes, 01/01/1970 00:00:00 UTC is the origin of timestamp for Unix
    systems. FM does not respect this standard and uses its own origin.

    Generally speaking, databases are managed on unix systems and therefore
    use 01/01/1970.



    Are there databases using timestamps as seconds after 1st January,
    1970, 00h00?


    ... maybe, but to what end ?




    --
    kurtz le pirate
    compagnie de la banquise

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)