SQlite not logging much

Matt,

I'm at work so I want to do this over an ssh connection, can I stop and start the server from terminal? If so what are the commands?

thanks,

bob

Matt,

That seems to of done it but the times are not local which makes it confusing to compare entries with the local time. How can I set the table to use local time? I see someone else asked you this but I don't understand your reply.

regards,

bob

Matt,

OK I see how to convert UTC to local times using this query but it only shows the ts column. How can I select all and convert the time in the same Query

SELECT ALL datetime(ts,'localtime') from variable_history

regards,

bob

[matt (support)]

Hi Bob,

I'm not following your question. If you want to select more than the "ts" column, then you need to add the columns you want to select to your query.

Regards,
Matt

Matt,

I don't know much about SQlite yet and I can't figure out how to select more than the ts column. I want to show all column with the ts in local time.

thanks,

bob

[matt (support)]

You have to put in the query the specific table columns you want to select like this:

Code: Select all

SELECT datetime(ts,'localtime'), var_name, var_value from variable_history

Regards,
Matt