Format DATE
- Mariia Romanova
Function FORMATDATE() allows you to modificate format column CREATED in that format date as comfortable for you.
Nomenclature:
YYYY - year in 4 number format (2022)
YY- year in 2 number format (22)
M - month (5)
MM - month in 2 number format (05)
DD - date in 2 number format (29) or (08)
hh - hours
mm - minutes
a - add AM/PM formats
LLL - Month,DD,YYYY hh:mm AM/PM
L - MM/DD/YYYY
ll - Mon Day,YYYY
EXAMPLES
PROJECTNAME* is a tentative name in our queries. Please note that in your JQLs you need to use real names of your Projects, Users, Sprints ,etc.
YYYY-MM-DD hh:mm AM/PM
FORMATEDATE ('YYYY-MM-DD hh:mm a')
select i.`KEY` as `Issue`,
FORMATDATE(i.CREATED,'yyyy-MM-DD hh:mm a') as `Created`
from ISSUE i
where JQL='project = PROJECTNAME'
Month- DD- YYYY, hh:mm AM/PM
FORMATEDATE ('LLL')
select i.`KEY` as `Issue`,
FORMATDATE(i.CREATED,'LLL') as `Created`
from ISSUE i
where JQL='project = PROJECTNAME'
MM/DD/YYYY
FORMATEDATE('L')
select i.`KEY` as `Issue`,
FORMATDATE(i.CREATED,'L') as `Created`
from ISSUE i
where JQL='project = PROJECTNAME'
Multiple date formats
for different columns which contain Dates
PROJECTNAME* is a tentative name in our queries. Please note that in your JQLs you need to use real names of your Projects, Users, Sprints ,etc.