I do not want to assume anything. Is startofday considered 12 AM of the day you run the query?
Thus, if you run a query at 11/17/14 3:30 PM, that uses startofday then the startofday is 11/17/14 12:00 AM?
It does not, you are right.
The time it works on is midnight, down to milliseconds.
A day is 86,400,000 milliseconds long, so imagine that 0 milliseconds is midnight and hence 0-1 is the first millisecond of the day. 86,399,999 is the last millisecond of the day.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG