Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

search history based on hour:minute #107

Open
chohman-daxko opened this issue May 11, 2021 · 0 comments
Open

search history based on hour:minute #107

chohman-daxko opened this issue May 11, 2021 · 0 comments

Comments

@chohman-daxko
Copy link

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 ...'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant