Try: SELECT FROM_UNIXTIME(dateTime) FROM weewx.archive;
-tk On Wed, Jul 10, 2019 at 8:51 AM jose riaño <[email protected]> wrote: > 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 > > > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/3493ed5e-ba79-495d-9dfc-979c5f76f064%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/3493ed5e-ba79-495d-9dfc-979c5f76f064%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEB7QRXJCeKh4MSJeyMx7s4cCV3ajzqbjg4FBRAKxjSDFw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
