I am a bit confused based on the documentation on how to take a Unix / Epoch Time and convert it into an ISO date i tried for Example SELECT DATE_FORMAT_STR('1463284740000','1111-11-11') but that always produces null. So what i am looking for is a simple way to convert a Epoch/UNIX Timestamps to…

How to convert Unix Epoch to Date

vsr1 August 2, 2020, 9:37pm 4

It looks like your start is seconds. MILLIS_TO_STR() first argument expects milliseconds. You need to multiply 1000

Topic		Replies	Views
Need to convert a short date in format YYYYMMdd to epochDay SQL++	2	556	November 25, 2022
Date Function questions SQL++ n1ql	2	1955	February 17, 2016
Create indexes based on EPOCH time or ISO-8601 SQL++ n1ql , server	3	1667	February 2, 2019
How to convert a date attribute format SQL++ n1ql	9	10748	April 18, 2021
How to select format date? SQL++	1	1844	August 11, 2016