Re: [weewx-user] Decode the value of the DateTime field
I said you could use a variety of functions!! On Sunday, 17 December 2017 06:26:15 UTC+2, Mielmari wrote: > > Hello > I found a way to decode the unix time to -mm-dd hh: mm: ss within > SQLite using using this query (in this case the epoch is 1512022128) > > SELECT datetime (1512022128, 'unixepoch', 'localtime'); ---> 2017-11-30 > 07:08:48 > > This way I can review the records in the same database > > > -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [weewx-user] Decode the value of the DateTime field
Hello I found a way to decode the unix time to -mm-dd hh: mm: ss within SQLite using using this query (in this case the epoch is 1512022128) SELECT datetime (1512022128, 'unixepoch', 'localtime'); ---> 2017-11-30 07:08:48 This way I can review the records in the same database -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [weewx-user] Decode the value of the DateTime field
Thanks! El viernes, 15 de diciembre de 2017, 8:35:06 (UTC+1), Glenn McKechnie escribió: > > It's Unixtime or epochtime. Run the command > man date > from a terminal window and you'll be bedazzled by the options. > > To convert that number string to something human readable, enter the > following into your terminal and press enter. > > date -d @1510918732 > > > > > > Cheers > Glenn > > rorpi - read only raspberry pi & various weewx addons > https://github.com/glennmckechnie > > On 15 December 2017 at 17:25, Mielmari > > wrote: > >> >> Hello >> Using DB Browser for SQLite, in the database in the field 'dateTime' I >> see values like this "1510918732". How is this value converted to year, >> month, day, hour etc? >> >> Thanks for your kind help. >> >> -- >> 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 . >> 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [weewx-user] Decode the value of the DateTime field
It's Unixtime or epochtime. Run the command man date from a terminal window and you'll be bedazzled by the options. To convert that number string to something human readable, enter the following into your terminal and press enter. date -d @1510918732 Cheers Glenn rorpi - read only raspberry pi & various weewx addons https://github.com/glennmckechnie On 15 December 2017 at 17:25, Mielmari wrote: > > Hello > Using DB Browser for SQLite, in the database in the field 'dateTime' I see > values like this "1510918732". How is this value converted to year, > month, day, hour etc? > > Thanks for your kind help. > > -- > 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+unsubscr...@googlegroups.com. > 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[weewx-user] Decode the value of the DateTime field
Hello Using DB Browser for SQLite, in the database in the field 'dateTime' I see values like this "1510918732". How is this value converted to year, month, day, hour etc? Thanks for your kind help. -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.