DateTimeExtractAndTransform

ElementMissed InstructionsCov.Missed BranchesCov.MissedCxtyMissedLinesMissedMethods
Total976 of 3,90174%72 of 25071%12836114163472221
previousDay(DateV2Literal, StringLiteral)340%40%336611
nextDay(DateV2Literal, StringLiteral)330%40%336611
weekOfYear(DateTimeV2Literal)311532%7112%454601
weekOfYear(DateV2Literal)311532%7112%453501
toSeconds(TimeStampNsLiteral)260%n/a112211
dayMicrosecond(TimeStampNsLiteral)250%n/a114411
hourMicrosecond(TimeStampNsLiteral)220%n/a113311
daySecond(TimeStampNsLiteral)200%n/a113311
makeTime(BigIntLiteral, BigIntLiteral, DoubleLiteral)1910384%8642%7842001
timeFormat(TimeStampNsLiteral, StringLikeLiteral)190%20%223311
minuteMicrosecond(TimeStampNsLiteral)190%n/a113311
lastDay(TimeStampNsLiteral)190%n/a113311
dayMinute(TimeStampNsLiteral)170%n/a113311
hourSecond(TimeStampNsLiteral)170%n/a113311
secondMicrosecond(TimeStampNsLiteral)160%n/a112211
century(TimeStampNsLiteral)140%n/a111111
quarter(TimeStampNsLiteral)140%n/a111111
dayHour(TimeStampNsLiteral)140%n/a112211
hourMinute(TimeStampNsLiteral)140%n/a112211
minuteSecond(TimeStampNsLiteral)140%n/a112211
unixTimestamp(TimeStampNsLiteral)140%n/a112211
yearWeek(LocalDateTime, int)1315392%11090%11023101
yearMonth(TimeStampNsLiteral)130%n/a112211
toSeconds(DateV2Literal)130%n/a111111
weekDay(TimeStampNsLiteral)130%n/a111111
getDayOfWeek(String)130%20%224411
fromUnixTime(BigDecimal, StringLikeLiteral)126985%2250%2321601
secondFromUnixtime(BigIntLiteral)123473%4450%353901
toDays(DateTimeV2Literal)120%n/a111111
toDays(TimeStampNsLiteral)120%n/a111111
quartersDiff(DateV2Literal, DateV2Literal)120%n/a111111
dayOfWeek(TimeStampNsLiteral)110%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
convertMonthToPeriod(long)101864%3125%231401
dateV2(TimeStampNsLiteral)100%n/a111111
date(TimeStampNsLiteral)100%n/a111111
toDate(TimeStampNsLiteral)100%n/a111111
weekOfYear(TimeStampNsLiteral)100%n/a111111
dayName(TimeStampNsLiteral)100%n/a112211
monthName(TimeStampNsLiteral)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
minutesDiff(DateTimeV2Literal, DateV2Literal)90%n/a111111
minutesDiff(DateV2Literal, DateTimeV2Literal)90%n/a111111
minutesDiff(DateV2Literal, DateV2Literal)90%n/a111111
month(TimeStampNsLiteral)80%n/a111111
day(DateV2Literal)80%n/a111111
day(DateTimeV2Literal)80%n/a111111
day(TimeStampNsLiteral)80%n/a111111
hour(TimeStampNsLiteral)80%n/a111111
minute(TimeStampNsLiteral)80%n/a111111
second(TimeStampNsLiteral)80%n/a111111
dayOfMonth(TimeStampNsLiteral)80%n/a111111
fromUnixTime(BigIntLiteral, StringLikeLiteral)76490%1375%1311301
microsecond(TimeStampNsLiteral)70%n/a111111
dayOfYear(TimeStampNsLiteral)70%n/a111111
dateTrunc(StringLikeLiteral, TimeStampNsLiteral)70%n/a112211
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
validatePeriod(long)61773%3350%341301
week(TimeStampNsLiteral, IntegerLiteral)60%n/a111111
yearWeek(TimeStampNsLiteral, IntegerLiteral)60%n/a111111
week(LocalDateTime, int)515396%31482%31312301
dateFormat(TimeStampNsLiteral, StringLikeLiteral)51878%1150%121401
timeFormat(DateTimeV2Literal, StringLikeLiteral)51473%1150%121301
timeFormat(TimeV2Literal, StringLikeLiteral)51372%1150%121301
toMonday(TimeStampNsLiteral)50%n/a111111
fromUnixTime(DecimalLiteral, StringLikeLiteral)50%n/a111111
week(TimeStampNsLiteral)50%n/a111111
yearWeek(TimeStampNsLiteral)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
calcDayNumber(long, long, long)26997%21083%2711001
getSessionLocale()23093%4450%451701
checkAndConvertPeriodToMonth(long)22893%1375%130501
timestamp(TimeStampNsLiteral)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
makeTime(BigIntLiteral, BigIntLiteral, BigIntLiteral)70100%14100%0801001
validateTimezoneOffset(String)65100%11995%11101101
fromMicroSecond(long, int)56100%4100%030801
getTimestamp(LocalDateTime, int)53100%4100%0301101
toMonday(LocalDateTime)37100%4100%030501
minuteFromUnixtime(BigIntLiteral)37100%1375%130601
convertTz(LocalDateTime, StringLikeLiteral, StringLikeLiteral)35100%n/a0101101
unixTimestamp(StringLikeLiteral, StringLikeLiteral)33100%n/a010801
strToDate(StringLikeLiteral, StringLikeLiteral)33100%4100%030801
hourFromUnixtime(BigIntLiteral)32100%1375%130601
fromDays(IntegerLiteral)30100%2100%020501
toSeconds(DateTimeV2Literal)26100%n/a010201
dayMicrosecond(DateTimeV2Literal)25100%n/a010401
timestampNsDiff(TimeStampNsLiteral, TimeStampNsLiteral, long)24100%n/a010401
dateFormat(DateTimeV2Literal, StringLikeLiteral)23100%2100%020401
hourMicrosecond(DateTimeV2Literal)22100%n/a010301
daySecond(DateTimeV2Literal)20100%n/a010301
minuteMicrosecond(DateTimeV2Literal)19100%n/a010301
lastDay(DateV2Literal)19100%n/a010301
lastDay(DateTimeV2Literal)19100%n/a010301
unixTimestamp(DateTimeV2Literal)19100%n/a010301
padMicro(int)17100%2100%020301
dayMinute(DateTimeV2Literal)17100%n/a010301
hourSecond(DateTimeV2Literal)17100%n/a010301
secondMicrosecond(DateTimeV2Literal)16100%n/a010201
century(DateV2Literal)14100%n/a010101
century(DateTimeV2Literal)14100%n/a010101
quarter(DateV2Literal)14100%n/a010101
quarter(DateTimeV2Literal)14100%n/a010101
dayHour(DateTimeV2Literal)14100%n/a010201
hourMinute(DateTimeV2Literal)14100%n/a010201
minuteSecond(DateTimeV2Literal)14100%n/a010201
yearMonth(DateTimeV2Literal)13100%n/a010201
weekDay(DateV2Literal)13100%n/a010101
weekDay(DateTimeV2Literal)13100%n/a010101
periodAdd(BigIntLiteral, BigIntLiteral)13100%n/a010201
periodDiff(BigIntLiteral, BigIntLiteral)13100%n/a010201
toDays(DateV2Literal)12100%n/a010101
quartersDiff(DateTimeV2Literal, DateTimeV2Literal)12100%n/a010101
quartersDiff(TimestampTzLiteral, TimestampTzLiteral)12100%n/a010101
quartersDiff(TimeStampNsLiteral, TimeStampNsLiteral)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
convertTz(DateTimeV2Literal, StringLikeLiteral, StringLikeLiteral)10100%n/a010201
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(TimestampTzLiteral, TimestampTzLiteral)10100%n/a010101
monthsDiff(TimeStampNsLiteral, TimeStampNsLiteral)10100%n/a010101
monthsDiff(DateV2Literal, DateV2Literal)10100%n/a010101
yearsDiff(DateTimeV2Literal, DateTimeV2Literal)10100%n/a010101
yearsDiff(TimestampTzLiteral, TimestampTzLiteral)10100%n/a010101
yearsDiff(TimeStampNsLiteral, TimeStampNsLiteral)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
year(TimeStampNsLiteral)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
microsecondsDiff(TimeStampNsLiteral, TimeStampNsLiteral)8100%n/a010101
millisecondsDiff(TimeStampNsLiteral, TimeStampNsLiteral)8100%n/a010101
secondsDiff(TimeStampNsLiteral, TimeStampNsLiteral)8100%n/a010101
minutesDiff(TimeStampNsLiteral, TimeStampNsLiteral)8100%n/a010101
hoursDiff(TimeStampNsLiteral, TimeStampNsLiteral)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(TimeStampNsLiteral, StringLikeLiteral)7100%n/a010201
dateTrunc(DateV2Literal, StringLikeLiteral)7100%n/a010101
fromUnixTime(BigIntLiteral)7100%n/a010101
fromUnixTime(DecimalV3Literal)7100%n/a010101
convertTz(TimeStampNsLiteral, StringLikeLiteral, StringLikeLiteral)7100%n/a010201
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(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
getTimestamp(LocalDateTime)4100%n/a010101
daysDiff(DateTimeV2Literal, DateTimeV2Literal)4100%n/a010101
daysDiff(TimestampTzLiteral, TimestampTzLiteral)4100%n/a010101
daysDiff(TimeStampNsLiteral, TimeStampNsLiteral)4100%n/a010101
weeksDiff(DateTimeV2Literal, DateTimeV2Literal)4100%n/a010101
weeksDiff(TimestampTzLiteral, TimestampTzLiteral)4100%n/a010101
weeksDiff(TimeStampNsLiteral, TimeStampNsLiteral)4100%n/a010101
timestamp(DateTimeV2Literal)2100%n/a010101