See this this thread for unix time, both SQL and MySQL. You must have edited one of your questions, you had earlier asked how to do it.
See this for queries and parameters, don't forget the manual is awesome!:
https://docs.inductiveautomation.com/display/DOC81/system.db.runNamedQuery