Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

What is interpretted as startofday()

Mark Gordon
Mark Gordon 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.

 

 

Answer
Watch
Like Be the first to like this
13560 views

1 answer

0 votes
Pedro Cora
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

View More Comments
Ivy Clark
Ivy Clark July 8, 2018

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

Like • # people like this
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
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
Arun Singh May 2, 2019

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

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events