Trying to search histdb --from hour:minute but it isn't working as expected.
histdb to.login --from 12:00 --exact
Error: near ":00": syntax error
Error: near ":00": syntax error
error in -header -separator select strftime(case when datetime(max_start, 'unixepoch') > datetime('now', 'start of day') then '%H:%M' else '%d/%m' end, max_start, 'unixepoch', 'localtime') as time, session as ses, dir, argv as cmd from (select session, replace(places.dir, '/Users/collin.hohman', '~') as dir, replace(commands.argv, '
', '
') as argv, max(start_time) as max_start
from
commands
join history on history.command_id = commands.id
join places on history.place_id = places.id
where 1 and places.host='CDT-M-2271' and datetime(start_time, 'unixepoch') >= 12:00 and commands.argv = 'to.login'
group by history.command_id, history.place_id
order by max_start desc
limit 18) order by max_start asc
histdb:240: bad math expression: operator expected at `in select ...'
Trying to search histdb --from hour:minute but it isn't working as expected.
histdb to.login --from 12:00 --exactError: near ":00": syntax error Error: near ":00": syntax error error in -header -separator select strftime(case when datetime(max_start, 'unixepoch') > datetime('now', 'start of day') then '%H:%M' else '%d/%m' end, max_start, 'unixepoch', 'localtime') as time, session as ses, dir, argv as cmd from (select session, replace(places.dir, '/Users/collin.hohman', '~') as dir, replace(commands.argv, ' ', ' ') as argv, max(start_time) as max_start from commands join history on history.command_id = commands.id join places on history.place_id = places.id where 1 and places.host='CDT-M-2271' and datetime(start_time, 'unixepoch') >= 12:00 and commands.argv = 'to.login' group by history.command_id, history.place_id order by max_start desc limit 18) order by max_start asc histdb:240: bad math expression: operator expected at `in select ...'