Edit database

WxManAJB

unread,

Jul 13, 2019, 10:33:02 PM7/13/19

to weewx-user

Hello,

I'm having a difficult time with the instructions for editing my database and looking for some assistance.

I was checking my rain gauge today and tipped the cup several times, essentially, registering rain on Saturday when there was none, between noon and 3pm.

I'd like to clear that out. Can someone clue me in on the sqlite command that would do that? I'd be looking to target that specific timeframe, so date and time are part of the command.

Thanks!

p q

unread,

Jul 13, 2019, 10:55:27 PM7/13/19

to weewx...@googlegroups.com

I use DB Browser to fix data issues, but I'm sure someone can give you the commands. You will probably need to convert the time into UnixEpocs for the dateTime field. I like this site: https://www.epochconverter.com/

--
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/9073a0ed-48bc-48a2-8e7a-2bad04b94095%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Peter Quinn
(415)794-2264

Andrew Milner

unread,

Jul 13, 2019, 11:53:27 PM7/13/19

to weewx-user

the place to start is the user manual

http://weewx.com/docs/usersguide.htm#spikes

should give you a good starting point

On Sunday, 14 July 2019 05:55:27 UTC+3, p q wrote:

I use DB Browser to fix data issues, but I'm sure someone can give you the commands. You will probably need to convert the time into UnixEpocs for the dateTime field. I like this site: https://www.epochconverter.com/

On Sat, Jul 13, 2019 at 7:33 PM WxManAJB <ajburn...@gmail.com> wrote:

Hello,

I'm having a difficult time with the instructions for editing my database and looking for some assistance.

I was checking my rain gauge today and tipped the cup several times, essentially, registering rain on Saturday when there was none, between noon and 3pm.

I'd like to clear that out. Can someone clue me in on the sqlite command that would do that? I'd be looking to target that specific timeframe, so date and time are part of the command.

Thanks!

--
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...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/9073a0ed-48bc-48a2-8e7a-2bad04b94095%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Peter Quinn
(415)794-2264

Reply all

Reply to author

Forward