samwoo Posted July 25, 2016 Share Posted July 25, 2016 Hello, When it comes to querying and using functions related to dates (such as CURDATE() or h_datelogged) it doesnt work Few examples: DATE_FORMAT(h_datelogged,'%d') does not produce the day... in fact nothing in this function works, it just produces a blank field CURDATE() doesn't work DATE(h_datelogged) produces an empty field DAY(h_datelogged) produces an empty field. We have tried different variants but the all produce empty fields. Only when we query h_datelogged it brings back a value. And i think it does the same thing for other date fields too. Is there any pure documentation for the SQL that can be used in Hornbill? Thanks, Samuel Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now