B4J Question datetime from mysql

[TomDuncan]

Hi All,
I have a field in a mysql table which gives the result like "1517191800"
How can I display this as the correct time. (Around 1pm on 29th Jan 2018)
Timezone is +11 hrs (10 + daylightsaving) (Hobart, Australia)
Tom

 

[Roycefer]

In B4J:

Dim t As Long = YourVal  'YourVal is the result from the table
Log($"$DateTime{t*1000}"$)

In SQL, you can use the DATETIME method:

SELECT DATETIME(fieldname, 'unixepoch','localtime') FROM tablename WHERE blah blah blah

 

[TomDuncan]

Thanks for that works like a charm