I am looking at deleting some data from days when the pi crashed so that I get good average figures in the graphs but I cant work out the date format.
The following entry in the database was created at approximately 18:44 on 13/0413. I can see the year but the rest of the format throws me....
1365875094
Could someone point me in the right direction please?
Re: Deleting data - Time format?
Hi David, I believe that the date/time number equals the number of seconds elapsed since the Unix Epoch (Jan 1st 1970 00:00:00 GMT). In other words, it's in Unix format.
Try a online convertor, and input your example number, and you will get 13 April 2013 - 5.44pm GMT.
Paul
Re: Deleting data - Time format?
I see, many thanks Paul, I am familiar with SQL reports but new to Linux/unix and hadn't come across Unix Epoch.
i did search for various time formats but didn't see this one. Thanks again, learning something new everyday here and it's thoroughly enjoyable to be part of this!
David