MS Access – Převod Unix-timestamp do MS Access Date/Time formátu
SELECT Format(([tabulka.sloupec_datum_unix_timestamp]+2209161600)/86400,"dd/mm/yyyy hh:nn:ss") AS datum FROM tabulka
1476309600 -> 12.10.2016 22:00:00
SELECT Format(([tabulka.sloupec_datum_unix_timestamp]+2209161600)/86400,"dd/mm/yyyy hh:nn:ss") AS datum FROM tabulka
1476309600 -> 12.10.2016 22:00:00