You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am querying the table
SELECT TIMEORIGINALESTIMATE FROM JIRASchema.jiraissue ji (NOLOCK)
WHERE ji.TIMEORIGINALESTIMATE IS NOT NULL
The issue is when I export some of the values are coming as seconds and some of them are coming as minutes. Why is this? How can I make it consistent across all values.
Ex: UI shows for INTs
ticket 1: field value: TIMEORIGINALESTIMATE - 60 UI shows 1h
ticket 2: field value: TIMEORIGINALESTIMATE - 3600 UI shows 1h
ticket 3: field value: TIMEORIGINALESTIMATE -18000 UI shows 5h
This does not work because nothing is consistent and I can't provide the correct time period for this field.