Fecha de los datos tomados en mysql

34 views
Skip to first unread message

jose riaño

unread,
Jul 10, 2019, 11:51:55 AM7/10/19
to weewx-user
estoy tomando datos  en mysql y me pasa que obtengo esto:

| dateTime    | usUnits | interval | barometer | pressure | altimeter | inTemp | outTemp | inHumidity | outHumidity | windSpeed | windDir | windGust | windGustDir | rainRate | rain | dewpoint         | windchill | heatindex | ET   | radiation | UV   | extraTemp1 | extraTemp2 | extraTemp3 | soilTemp1 | soilTemp2 | soilTemp3 | soilTemp4 | leafTemp1 | leafTemp2 | extraHumid1 | extraHumid2 | soilMoist1 | soilMoist2 | soilMoist3 | soilMoist4 | leafWet1 | leafWet2 | rxCheckPercent   | txBatteryStatus | consBatteryVoltage | hail | hailRate | heatingTemp | heatingVoltage | supplyVoltage | referenceVoltage | windBatteryStatus | rainBatteryStatus | outTempBatteryStatus | inTempBatteryStatus |

+------------+---------------------+---------+----------+-----------+----------+-----------+--------+---------+------------+-------------+-----------+---------+----------+-------------+----------+------+------------------+-----------+-----------+------+-----------+------+------------+------------+------------+-----------+-----------+-----------+-----------+-----------+-----------+-------------+-------------+------------+------------+------------+------------+----------+----------+------------------+-----------------+--------------------+------+----------+-------------+----------------+---------------+------------------+-------------------+-------------------+----------------------+---------------------+

| 1562763600 |       1 |        1 |    24.585 |   24.585 | 24.576141 |   68.8 |    65.2 |         60 |          76 |         1 |     270 |        2 |       247.5 |        0 |    0 | 57.4377187574385 |      65.2 |      65.2 |    0 |      NULL | NULL |       NULL |       NULL |       NULL |      NULL |      NULL |      NULL |      NULL |      NULL |      NULL |        NULL |        NULL |       NULL |       NULL |       NULL |       NULL |     NULL |     NULL | 85.4166666666667 |               0 |               1.83 | NULL |     NULL |        NULL |           NULL |          NULL |             NULL |              NULL |              NULL |                 NULL |                NULL |

+------------+---------------------+---------+----------+-----------+----------+-----------+--------+---------+------------+-------------+-----------+---------+----------+-------------+----------+------+------------------+-----------+-----------+------+-----------+------+------------+------------+------------+-----------+-----------+-----------+-----------+-----------+-----------+-------------+-------------+------------+------------+------------+------------+----------+----------+------------------+-----------------+--------------------+------+----------+-------------+----------------+---------------+------------------+-------------------+-------------------+----------------------+---------------------+



cual es la hora y la fecha del dato y como la convierto tengo entendido que toma la hora de la consola pero como lo hace y como la hago entendible...



muchas gracias 

 

Thomas Keffer

unread,
Jul 10, 2019, 12:27:59 PM7/10/19
to weewx-user
Try:

SELECT FROM_UNIXTIME(dateTime) FROM weewx.archive;

-tk

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3493ed5e-ba79-495d-9dfc-979c5f76f064%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

jose riaño

unread,
Jul 11, 2019, 11:06:49 AM7/11/19
to weewx-user
Muchas gracias amigo....
To unsubscribe from this group and stop receiving emails from it, send an email to weewx...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages