dateTime to Readable format

[Caleb Pocock]

Hello,

I am using a Vantage Pro2 weather station and am storing the data on a MySQL server, however the dateTime column is a long (example: '1383062640'), and I am having difficulty figuring out how to convert that into something that I can understand.

Thanks

[Heli Os]

On linux/unix you could use "date"

like:
~$ date -d @1383062640
Tue Oct 29 17:04:00 CET 2013

[Thomas Keffer]

The column dateTime is in "unix epoch time," which, as you've discovered, is a big opaque number. 

You didn't say why and where you need to convert it. If it's just for oversight purposes using the mysql command line interface, then use the FROM_UNIXTIME() function:

mysql> SELECT FROM_UNIXTIME(dateTime) FROM weewx.archive LIMIT 5;

will print out the first five timestamps in your archive database in local time.

-tk

Tom Keffer

kef...@threefools.org
+1 541-386-8891 (h)
+1 541-490-9507 (c)

Skype: tkeffer

--
You received this message because you are subscribed to the Google Groups "Weewx user's group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[John Masters]

FWIW i used http://www.epochconverter.com/

[Andrew Milner]

and I always use http://www.freeformatter.com/epoch-timestamp-to-date-converter.html