How to convert an Epoch to a OffsetDateTime in Kotlin?

Question

The postgresql Timestamp with Time Zone data type needs to be supplied an OffsetDateTime when being called using a High level language like Kotlin. I could not find a direct method that supports Epoch to OffsetDateTime conversion.

score 15 · Accepted Answer · answered May 03 '19 at 18:35

fun convertEpochToOffsetDateTime(epochValue: Long): OffsetDateTime {
  return OffsetDateTime.of(LocalDateTime.ofEpochSecond(epochValue, 0, ZoneOffset.UTC), ZoneOffset.UTC)
}

Btw, I'm using Jooq for SQL queries using Kotlin. The above works like a charm.

score 9 · Answer 2 · answered Oct 27 '20 at 07:56

9

Another way is to go from Long -> Instant -> OffsetDateTime

OffsetDateTime.ofInstant(Instant.ofEpochMilli(started_at), ZoneOffset.UTC)

answered Oct 27 '20 at 07:56

34m0

5,755
1
30
22

this does not work, try converting 1613989887 which is "2021-02-22T10:31:27Z". your code will yield "1970-01-19T16:19:49.887Z" – Uri Loya Feb 22 '21 at 10:33
1

Note the difference between seconds and milliseconds from epoc. Your value is seconds from epoc, append three zeros to it and you will get the expected answer. – 34m0 Feb 22 '21 at 12:16

score 0 · Answer 3 · answered May 15 '19 at 21:39

Another way I just found:

fun dateFormatter(epoch: Long): String {
        // epoch = 1557954848
        val date = Date(epoch * 1000L)
        val sdf = SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSSSS")
        return sdf.format(date)
        // returned value = "2019-05-15 14:14:08.000000"
}

How to convert an Epoch to a OffsetDateTime in Kotlin?

3 Answers3