Needing the expression/Formula to turn Seconds

[BamaGirl]

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

 

[CJ_London]

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]

1407182400 is 8/4/2014 20:00

It's the number of seconds his date/time occured after 1/1/1970 00:00 (http://www.unixtimestamp.com/).

So, to convert that to a date/time you would use the DateAdd function in Access:

https://www.techonthenet.com/access/functions/date/dateadd.php

Then to get the format you want you use the Format function:

https://www.techonthenet.com/access/functions/date/format.php