SQL TIMESTAMP strftime

Question

as from strftime('%s', CURRENT_TIMESTAMP) back to normal normal format

Novitskiy Denis

1,128 3 20

Clool Mear

52 9

What kind of database? If SQLLite - try SELECT datetime (1092941466, 'unixepoch') - Novitskiy Denis
Thank you for help - Clool Mear

|

1 answer 1

Novitskiy Denis Novitskiy Denis 1,128 3 20 · Answer 1 · 2018-04-16T05:58:51

Use Datetime:

 SELECT datetime(1092941466, 'unixepoch')