DateTimeExtractAndTransform

ElementMissed InstructionsCov.Missed BranchesCov.MissedCxtyMissedLinesMissedMethods
Total967 of 3,25170%102 of 24658%12730114154157163
makeTime(BigIntLiteral, BigIntLiteral, BigIntLiteral)700%140%88101011
previousDay(DateV2Literal, StringLiteral)340%40%336611
nextDay(DateV2Literal, StringLiteral)330%40%336611
weekOfYear(DateTimeV2Literal)311532%7112%454601
weekOfYear(DateV2Literal)311532%7112%453501
checkAndConvertPeriodToMonth(long)300%40%335511
convertMonthToPeriod(long)280%40%334411
toSeconds(DateTimeV2Literal)260%n/a112211
dayMicrosecond(DateTimeV2Literal)250%n/a114411
validatePeriod(long)230%60%443311
hourMicrosecond(DateTimeV2Literal)220%n/a113311
makeTime(BigIntLiteral, BigIntLiteral, DoubleLiteral)1910384%8642%7842001
timeFormat(DateTimeV2Literal, StringLikeLiteral)190%20%223311
minuteMicrosecond(DateTimeV2Literal)190%n/a113311
week(LocalDateTime, int)1814088%41376%41332301
timeFormat(TimeV2Literal, StringLikeLiteral)180%20%223311
padMicro(int)170%20%223311
hourSecond(DateTimeV2Literal)170%n/a113311
getTimestamp(LocalDateTime)163468%1375%1311001
secondMicrosecond(DateTimeV2Literal)160%n/a112211
century(DateV2Literal)140%n/a111111
century(DateTimeV2Literal)140%n/a111111
hourMinute(DateTimeV2Literal)140%n/a112211
minuteSecond(DateTimeV2Literal)140%n/a112211
yearWeek(LocalDateTime, int)1315392%11090%11023101
toSeconds(DateV2Literal)130%n/a111111
weekDay(DateTimeV2Literal)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
secondFromUnixtime(BigIntLiteral)123473%4450%353901
toDays(DateTimeV2Literal)120%n/a111111
quartersDiff(DateTimeV2Literal, DateTimeV2Literal)120%n/a111111
quartersDiff(DateV2Literal, DateV2Literal)120%n/a111111
hoursDiff(DateTimeV2Literal, DateV2Literal)110%n/a111111
hoursDiff(DateV2Literal, DateTimeV2Literal)110%n/a111111
hoursDiff(DateV2Literal, DateV2Literal)110%n/a111111
microsecondFromUnixtime(DecimalV3Literal)104581%2466%2411101
dayName(DateTimeV2Literal)100%n/a112211
monthName(DateTimeV2Literal)100%n/a112211
monthsDiff(DateTimeV2Literal, DateV2Literal)100%n/a111111
monthsDiff(DateV2Literal, DateTimeV2Literal)100%n/a111111
yearsDiff(DateTimeV2Literal, DateV2Literal)100%n/a111111
yearsDiff(DateV2Literal, DateTimeV2Literal)100%n/a111111
validateTimezoneOffset(String)95686%41680%31111101
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
calcDayNumber(long, long, long)76490%4866%4721001
dateTrunc(StringLikeLiteral, DateV2Literal)70%n/a111111
fromUnixTime(DecimalLiteral)70%n/a111111
secondsDiff(DateTimeV2Literal, DateV2Literal)70%n/a111111
secondsDiff(DateV2Literal, DateTimeV2Literal)70%n/a111111
secondsDiff(DateV2Literal, DateV2Literal)70%n/a111111
yearWeek(DateV2Literal, IntegerLiteral)60%n/a111111
fromUnixTime(DecimalLiteral, StringLikeLiteral)50%n/a111111
yearWeek(DateV2Literal)50%n/a111111
makeDate(IntegerLiteral, IntegerLiteral)43990%2675%251701
isSpecificDate(LocalDateTime)41578%3562%250201
daysDiff(DateTimeV2Literal, DateV2Literal)40%n/a111111
daysDiff(DateV2Literal, DateTimeV2Literal)40%n/a111111
daysDiff(DateV2Literal, DateV2Literal)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
toMonday(LocalDateTime)23594%1375%131501
getSessionLocale()23093%4450%451701
timestamp(DateTimeV2Literal)20%n/a111111
static {...}131100%n/a0102301
getFormat(StringLikeLiteral, StringLikeLiteral)92100%12095%11703701
monthsBetween(DateV2Literal, DateV2Literal, BooleanLiteral)83100%6100%0401201
dateTruncHelper(LocalDateTime, String)77100%9100%0802001
fromMicroSecond(long, int)56100%4100%030801
convertTz(DateTimeV2Literal, StringLikeLiteral, StringLikeLiteral)42100%n/a0101301
minuteFromUnixtime(BigIntLiteral)37100%1375%130601
unixTimestamp(StringLikeLiteral, StringLikeLiteral)33100%n/a010801
strToDate(StringLikeLiteral, StringLikeLiteral)33100%4100%030801
hourFromUnixtime(BigIntLiteral)32100%1375%130601
fromDays(IntegerLiteral)30100%2100%020501
dateFormat(DateTimeV2Literal, StringLikeLiteral)23100%2100%020401
daySecond(DateTimeV2Literal)20100%n/a010301
lastDay(DateV2Literal)19100%n/a010301
lastDay(DateTimeV2Literal)19100%n/a010301
unixTimestamp(DateTimeV2Literal)19100%n/a010301
dayMinute(DateTimeV2Literal)17100%n/a010301
quarter(DateV2Literal)14100%n/a010101
quarter(DateTimeV2Literal)14100%n/a010101
dayHour(DateTimeV2Literal)14100%n/a010201
yearMonth(DateTimeV2Literal)13100%n/a010201
weekDay(DateV2Literal)13100%n/a010101
toDays(DateV2Literal)12100%n/a010101
quartersDiff(TimestampTzLiteral, TimestampTzLiteral)12100%n/a010101
dayOfWeek(DateV2Literal)11100%n/a010101
dayOfWeek(DateTimeV2Literal)11100%n/a010101
hoursDiff(DateTimeV2Literal, DateTimeV2Literal)11100%n/a010101
hoursDiff(TimestampTzLiteral, TimestampTzLiteral)11100%n/a010101
secToTime(IntegerLiteral)11100%n/a010101
dateV2(DateTimeV2Literal)10100%n/a010101
date(DateTimeV2Literal)10100%n/a010101
toDate(DateTimeV2Literal)10100%n/a010101
dayName(DateV2Literal)10100%n/a010201
monthName(DateV2Literal)10100%n/a010201
fromSecond(BigIntLiteral)10100%n/a010101
monthsDiff(DateTimeV2Literal, DateTimeV2Literal)10100%n/a010101
monthsDiff(TimestampTzLiteral, TimestampTzLiteral)10100%n/a010101
monthsDiff(DateV2Literal, DateV2Literal)10100%n/a010101
yearsDiff(DateTimeV2Literal, DateTimeV2Literal)10100%n/a010101
yearsDiff(TimestampTzLiteral, TimestampTzLiteral)10100%n/a010101
yearsDiff(DateV2Literal, DateV2Literal)10100%n/a010101
padTwo(int)9100%2100%020101
dateTrunc(DateTimeV2Literal, StringLikeLiteral)9100%n/a010201
dateTrunc(StringLikeLiteral, DateTimeV2Literal)9100%n/a010201
unixTimestamp(DateV2Literal)9100%n/a010101
millisecondsDiff(DateTimeV2Literal, DateTimeV2Literal)9100%n/a010101
millisecondsDiff(TimestampTzLiteral, TimestampTzLiteral)9100%n/a010101
minutesDiff(DateTimeV2Literal, DateTimeV2Literal)9100%n/a010101
minutesDiff(TimestampTzLiteral, TimestampTzLiteral)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
dateTrunc(DateV2Literal, StringLikeLiteral)7100%n/a010101
fromUnixTime(BigIntLiteral)7100%n/a010101
fromUnixTime(DecimalV3Literal)7100%n/a010101
microsecondsDiff(DateTimeV2Literal, DateTimeV2Literal)7100%n/a010101
microsecondsDiff(TimestampTzLiteral, TimestampTzLiteral)7100%n/a010101
secondsDiff(DateTimeV2Literal, DateTimeV2Literal)7100%n/a010101
secondsDiff(TimestampTzLiteral, TimestampTzLiteral)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(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(DateTimeV2Literal)5100%n/a010101
daysDiff(DateTimeV2Literal, DateTimeV2Literal)4100%n/a010101
daysDiff(TimestampTzLiteral, TimestampTzLiteral)4100%n/a010101
weeksDiff(DateTimeV2Literal, DateTimeV2Literal)4100%n/a010101
weeksDiff(TimestampTzLiteral, TimestampTzLiteral)4100%n/a010101