Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

What is interpretted as startofday()

Mark Gordon
Contributor
November 17, 2014

JIRA,

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?

 

Thanks.

 

 

1 answer

0 votes
Pedro Cora
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 17, 2014

Yes Mark, that's right.

For more details, take a look at the documentation at https://confluence.atlassian.com/display/JIRA/Advanced+Searching+Functions

smile

-- Pedro

Ivy Clark July 8, 2018

The article doesn't actually mention what time startofday is.

Like # people like this
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 9, 2018

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.

Like John Funk likes this
Arun Singh May 2, 2019

StartOfDay(-x) or StartOfDay(x) indicates 'x' calendar days and not working days?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events