Since the last upgrade of SpiceWorks, our reports are not working. It appears to be a problem with the date function in SQLite.
How can I
test a function to see how it evaluates? For instance, the code contains this:
The report works if I put in a hard date, so I suspect that this is the problem child.
How can I see what these are evaluating to? I guess I'm looking for the SQL equivalent of System.out.println(), if such a thing exists.
I have WinSQL for browsing the database and running queries.