DateTimeExtractAndTransform

ElementMissed InstructionsCov.Missed BranchesCov.MissedCxtyMissedLinesMissedMethods
Total1,221 of 3,21762%130 of 25048%15530320653469163
getFormat(StringLikeLiteral, StringLikeLiteral)920%210%1717373711
microsecondFromUnixtime(DecimalV3Literal)550%60%44111111
secondFromUnixtime(BigIntLiteral)460%80%559911
minuteFromUnixtime(BigIntLiteral)370%40%336611
previousDay(DateV2Literal, StringLiteral)340%40%336611
nextDay(DateV2Literal, StringLiteral)330%40%336611
hourFromUnixtime(BigIntLiteral)320%40%336611
weekOfYear(DateTimeV2Literal)311532%7112%454601
weekOfYear(DateV2Literal)311532%7112%453501
checkAndConvertPeriodToMonth(long)300%40%335511
convertMonthToPeriod(long)280%40%334411
makeTime(BigIntLiteral, BigIntLiteral, DoubleLiteral)266270%11738%91051301
dayMicrosecond(DateTimeV2Literal)250%n/a114411
validatePeriod(long)230%60%443311
hourMicrosecond(DateTimeV2Literal)220%n/a113311
week(LocalDateTime, int)2113786%71058%41332301
daySecond(DateTimeV2Literal)200%n/a113311
minuteMicrosecond(DateTimeV2Literal)190%n/a113311
yearWeek(LocalDateTime, int)1714989%2981%21033101
padMicro(int)170%20%223311
dayMinute(DateTimeV2Literal)170%n/a113311
hourSecond(DateTimeV2Literal)170%n/a113311
secondMicrosecond(DateTimeV2Literal)160%n/a112211
isSpecificDate(LocalDateTime)14526%7112%450201
century(DateV2Literal)140%n/a111111
century(DateTimeV2Literal)140%n/a111111
dayHour(DateTimeV2Literal)140%n/a112211
hourMinute(DateTimeV2Literal)140%n/a112211
minuteSecond(DateTimeV2Literal)140%n/a112211
yearMonth(DateTimeV2Literal)130%n/a112211
toSeconds(DateV2Literal)130%n/a111111
getDayOfWeek(String)130%20%224411
periodAdd(BigIntLiteral, BigIntLiteral)130%n/a112211
periodDiff(BigIntLiteral, BigIntLiteral)130%n/a112211
fromUnixTime(BigDecimal, StringLikeLiteral)126985%2250%2321601
validateTimezoneOffset(String)125381%31785%31121101
toDays(DateTimeV2Literal)120%n/a111111
quartersDiff(DateTimeV2Literal, DateTimeV2Literal)120%n/a111111
quartersDiff(TimestampTzLiteral, TimestampTzLiteral)120%n/a111111
quartersDiff(DateV2Literal, DateV2Literal)120%n/a111111
makeDate(IntegerLiteral, IntegerLiteral)113274%4450%452701
hoursDiff(TimestampTzLiteral, TimestampTzLiteral)110%n/a111111
hoursDiff(DateTimeV2Literal, DateV2Literal)110%n/a111111
hoursDiff(DateV2Literal, DateTimeV2Literal)110%n/a111111
hoursDiff(DateV2Literal, DateV2Literal)110%n/a111111
monthsDiff(TimestampTzLiteral, TimestampTzLiteral)100%n/a111111
monthsDiff(DateTimeV2Literal, DateV2Literal)100%n/a111111
monthsDiff(DateV2Literal, DateTimeV2Literal)100%n/a111111
yearsDiff(TimestampTzLiteral, TimestampTzLiteral)100%n/a111111
yearsDiff(DateTimeV2Literal, DateV2Literal)100%n/a111111
yearsDiff(DateV2Literal, DateTimeV2Literal)100%n/a111111
padTwo(int)90%20%221111
unixTimestamp(DateV2Literal)90%n/a111111
millisecondsDiff(TimestampTzLiteral, TimestampTzLiteral)90%n/a111111
minutesDiff(TimestampTzLiteral, TimestampTzLiteral)90%n/a111111
minutesDiff(DateTimeV2Literal, DateV2Literal)90%n/a111111
minutesDiff(DateV2Literal, DateTimeV2Literal)90%n/a111111
minutesDiff(DateV2Literal, DateV2Literal)90%n/a111111
day(DateV2Literal)80%n/a111111
day(DateTimeV2Literal)80%n/a111111
fromUnixTime(BigIntLiteral, StringLikeLiteral)76490%1375%1311301
dateTrunc(DateV2Literal, StringLikeLiteral)70%n/a111111
dateTrunc(StringLikeLiteral, DateV2Literal)70%n/a111111
fromUnixTime(DecimalLiteral)70%n/a111111
microsecondsDiff(TimestampTzLiteral, TimestampTzLiteral)70%n/a111111
secondsDiff(TimestampTzLiteral, TimestampTzLiteral)70%n/a111111
secondsDiff(DateTimeV2Literal, DateV2Literal)70%n/a111111
secondsDiff(DateV2Literal, DateTimeV2Literal)70%n/a111111
secondsDiff(DateV2Literal, DateV2Literal)70%n/a111111
timeFormat(DateTimeV2Literal, StringLikeLiteral)51473%1150%121301
timeFormat(TimeV2Literal, StringLikeLiteral)51372%1150%121301
fromUnixTime(DecimalLiteral, StringLikeLiteral)50%n/a111111
daysDiff(TimestampTzLiteral, TimestampTzLiteral)40%n/a111111
daysDiff(DateTimeV2Literal, DateV2Literal)40%n/a111111
daysDiff(DateV2Literal, DateTimeV2Literal)40%n/a111111
daysDiff(DateV2Literal, DateV2Literal)40%n/a111111
weeksDiff(TimestampTzLiteral, TimestampTzLiteral)40%n/a111111
weeksDiff(DateTimeV2Literal, DateV2Literal)40%n/a111111
weeksDiff(DateV2Literal, DateTimeV2Literal)40%n/a111111
weeksDiff(DateV2Literal, DateV2Literal)40%n/a111111
DateTimeExtractAndTransform()30%n/a111111
calcDayNumber(long, long, long)26997%21083%2711001
getSessionLocale()23093%4450%451701
static {...}131100%n/a0102301
monthsBetween(DateV2Literal, DateV2Literal, BooleanLiteral)83100%6100%0401201
dateTruncHelper(LocalDateTime, String)77100%9100%0802001
makeTime(BigIntLiteral, BigIntLiteral, BigIntLiteral)70100%14100%0801001
fromMicroSecond(long, int)56100%4100%030801
getTimestamp(LocalDateTime)50100%4100%0301001
convertTz(DateTimeV2Literal, StringLikeLiteral, StringLikeLiteral)42100%n/a0101301
toMonday(LocalDateTime)37100%4100%030501
unixTimestamp(StringLikeLiteral, StringLikeLiteral)33100%n/a010801
strToDate(StringLikeLiteral, StringLikeLiteral)33100%4100%030801
fromDays(IntegerLiteral)30100%2100%020501
toSeconds(DateTimeV2Literal)26100%n/a010201
dateFormat(DateTimeV2Literal, StringLikeLiteral)23100%2100%020401
lastDay(DateV2Literal)19100%n/a010301
lastDay(DateTimeV2Literal)19100%n/a010301
unixTimestamp(DateTimeV2Literal)19100%n/a010301
quarter(DateV2Literal)14100%n/a010101
quarter(DateTimeV2Literal)14100%n/a010101
weekDay(DateV2Literal)13100%n/a010101
weekDay(DateTimeV2Literal)13100%n/a010101
toDays(DateV2Literal)12100%n/a010101
dayOfWeek(DateV2Literal)11100%n/a010101
dayOfWeek(DateTimeV2Literal)11100%n/a010101
hoursDiff(DateTimeV2Literal, DateTimeV2Literal)11100%n/a010101
secToTime(IntegerLiteral)11100%n/a010101
dateV2(DateTimeV2Literal)10100%n/a010101
date(DateTimeV2Literal)10100%n/a010101
toDate(DateTimeV2Literal)10100%n/a010101
dayName(DateTimeV2Literal)10100%n/a010201
dayName(DateV2Literal)10100%n/a010201
monthName(DateTimeV2Literal)10100%n/a010201
monthName(DateV2Literal)10100%n/a010201
fromSecond(BigIntLiteral)10100%n/a010101
monthsDiff(DateTimeV2Literal, DateTimeV2Literal)10100%n/a010101
monthsDiff(DateV2Literal, DateV2Literal)10100%n/a010101
yearsDiff(DateTimeV2Literal, DateTimeV2Literal)10100%n/a010101
yearsDiff(DateV2Literal, DateV2Literal)10100%n/a010101
dateTrunc(DateTimeV2Literal, StringLikeLiteral)9100%n/a010201
dateTrunc(StringLikeLiteral, DateTimeV2Literal)9100%n/a010201
millisecondsDiff(DateTimeV2Literal, DateTimeV2Literal)9100%n/a010101
minutesDiff(DateTimeV2Literal, DateTimeV2Literal)9100%n/a010101
weeksDiff(DateLiteral, DateLiteral)9100%n/a010101
secToTime(DoubleLiteral)9100%n/a010101
year(DateV2Literal)8100%n/a010101
year(DateTimeV2Literal)8100%n/a010101
month(DateV2Literal)8100%n/a010101
month(DateTimeV2Literal)8100%n/a010101
hour(DateTimeV2Literal)8100%n/a010101
minute(DateTimeV2Literal)8100%n/a010101
second(DateTimeV2Literal)8100%n/a010101
dayOfMonth(DateV2Literal)8100%n/a010101
dayOfMonth(DateTimeV2Literal)8100%n/a010101
fromMilliSecond(BigIntLiteral)8100%n/a010101
second(TimeV2Literal)7100%n/a010101
microsecond(DateTimeV2Literal)7100%n/a010101
dayOfYear(DateV2Literal)7100%n/a010101
dayOfYear(DateTimeV2Literal)7100%n/a010101
firstDayOfWeek(LocalDateTime)7100%n/a010101
fromUnixTime(BigIntLiteral)7100%n/a010101
fromUnixTime(DecimalV3Literal)7100%n/a010101
microsecondsDiff(DateTimeV2Literal, DateTimeV2Literal)7100%n/a010101
secondsDiff(DateTimeV2Literal, DateTimeV2Literal)7100%n/a010101
daysDiff(DateLiteral, DateLiteral)7100%n/a010101
microsecond(TimeV2Literal)6100%n/a010101
distanceToFirstDayOfWeek(LocalDateTime)6100%n/a010101
week(DateTimeV2Literal, IntegerLiteral)6100%n/a010101
week(DateV2Literal, IntegerLiteral)6100%n/a010101
yearWeek(DateV2Literal, IntegerLiteral)6100%n/a010101
yearWeek(DateTimeV2Literal, IntegerLiteral)6100%n/a010101
fromMicroSecond(BigIntLiteral)6100%n/a010101
toMonday(DateV2Literal)5100%n/a010101
toMonday(DateTimeV2Literal)5100%n/a010101
fromUnixTime(DecimalV3Literal, StringLikeLiteral)5100%n/a010101
week(DateTimeV2Literal)5100%n/a010101
week(DateV2Literal)5100%n/a010101
yearWeek(DateV2Literal)5100%n/a010101
yearWeek(DateTimeV2Literal)5100%n/a010101
daysDiff(DateTimeV2Literal, DateTimeV2Literal)4100%n/a010101
weeksDiff(DateTimeV2Literal, DateTimeV2Literal)4100%n/a010101
timestamp(DateTimeV2Literal)2100%n/a010101