Needing the expression/Formula to turn Seconds (1 Viewer)

BamaGirl

New member
Local time
Today, 00:59
Joined
Aug 8, 2017
Messages
1
Needing the expression/Formula to turn Seconds

I have unix timestamp that I need to turn into Date /Time

Example: 1407182400

Needing two columns

Column 1 Date: MM/DD/YYYY
Column 2 Time: HH:MM:SS

I need the expression or formula to do this in a Query
 
Last edited:

CJ_London

Super Moderator
Staff member
Local time
Today, 07:59
Joined
Feb 19, 2013
Messages
16,553
so what does 1407182400 translate to as date/time? something thing like

18/07/2014 00:00?

Although this does not include seconds, only hours and minutes

Without knowing that cannot be any more specific that look to use string functions such as mid, left, right
 

plog

Banishment Pending
Local time
Today, 02:59
Joined
May 11, 2011
Messages
11,613

Users who are viewing this thread

Top Bottom