Muchas gracias amigo....
El miércoles, 10 de julio de 2019, 11:27:59 (UTC-5), Thomas Keffer escribió: > > Try: > > SELECT FROM_UNIXTIME(dateTime) FROM weewx.archive; > > > -tk > > On Wed, Jul 10, 2019 at 8:51 AM jose riaño <[email protected] > <javascript:>> 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] <javascript:>. >> 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/1f8a116b-d081-4929-80fb-7bf02ff4ce86%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
