DateTimeExtractAndTransform

ElementMissed InstructionsCov.Missed BranchesCov.MissedCxtyMissedLinesMissedMethods
Total2,420 of 3,21724%223 of 25010%251303399534118163
yearWeek(LocalDateTime, int)1660%110%1010313111
getFormat(StringLikeLiteral, StringLikeLiteral)920%210%1717373711
makeTime(BigIntLiteral, BigIntLiteral, DoubleLiteral)880%180%1010131311
monthsBetween(DateV2Literal, DateV2Literal, BooleanLiteral)830%60%44121211
fromUnixTime(BigDecimal, StringLikeLiteral)810%40%33161611
week(LocalDateTime, int)788050%12529%913132301
fromUnixTime(BigIntLiteral, StringLikeLiteral)710%40%33131311
makeTime(BigIntLiteral, BigIntLiteral, BigIntLiteral)700%140%88101011
validateTimezoneOffset(String)6057%1915%101191101
fromMicroSecond(long, int)560%40%338811
microsecondFromUnixtime(DecimalV3Literal)550%60%44111111
secondFromUnixtime(BigIntLiteral)460%80%559911
makeDate(IntegerLiteral, IntegerLiteral)430%80%557711
toMonday(LocalDateTime)370%40%335511
minuteFromUnixtime(BigIntLiteral)370%40%336611
previousDay(DateV2Literal, StringLiteral)340%40%336611
unixTimestamp(StringLikeLiteral, StringLikeLiteral)330%n/a118811
nextDay(DateV2Literal, StringLiteral)330%40%336611
hourFromUnixtime(BigIntLiteral)320%40%336611
weekOfYear(DateTimeV2Literal)311532%7112%454601
weekOfYear(DateV2Literal)311532%7112%453501
fromDays(IntegerLiteral)300%20%225511
checkAndConvertPeriodToMonth(long)300%40%335511
convertMonthToPeriod(long)280%40%334411
toSeconds(DateTimeV2Literal)260%n/a112211
dayMicrosecond(DateTimeV2Literal)250%n/a114411
dateTruncHelper(LocalDateTime, String)245368%3666%3862001
validatePeriod(long)230%60%443311
hourMicrosecond(DateTimeV2Literal)220%n/a113311
calcDayNumber(long, long, long)215070%9325%6731001
daySecond(DateTimeV2Literal)200%n/a113311
timeFormat(DateTimeV2Literal, StringLikeLiteral)190%20%223311
minuteMicrosecond(DateTimeV2Literal)190%n/a113311
lastDay(DateV2Literal)190%n/a113311
lastDay(DateTimeV2Literal)190%n/a113311
getTimestamp(LocalDateTime)183264%2250%2321001
timeFormat(TimeV2Literal, StringLikeLiteral)180%20%223311
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
weekDay(DateTimeV2Literal)130%n/a111111
getDayOfWeek(String)130%20%224411
periodAdd(BigIntLiteral, BigIntLiteral)130%n/a112211
periodDiff(BigIntLiteral, BigIntLiteral)130%n/a112211
toDays(DateV2Literal)120%n/a111111
toDays(DateTimeV2Literal)120%n/a111111
quartersDiff(DateTimeV2Literal, DateTimeV2Literal)120%n/a111111
quartersDiff(TimestampTzLiteral, TimestampTzLiteral)120%n/a111111
quartersDiff(DateV2Literal, DateV2Literal)120%n/a111111
hoursDiff(TimestampTzLiteral, TimestampTzLiteral)110%n/a111111
hoursDiff(DateTimeV2Literal, DateV2Literal)110%n/a111111
hoursDiff(DateV2Literal, DateTimeV2Literal)110%n/a111111
hoursDiff(DateV2Literal, DateV2Literal)110%n/a111111
secToTime(IntegerLiteral)110%n/a111111
strToDate(StringLikeLiteral, StringLikeLiteral)102369%2250%232801
dateV2(DateTimeV2Literal)100%n/a111111
dayName(DateTimeV2Literal)100%n/a112211
monthName(DateTimeV2Literal)100%n/a112211
monthName(DateV2Literal)100%n/a112211
fromSecond(BigIntLiteral)100%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(DateTimeV2Literal, DateTimeV2Literal)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
weeksDiff(DateLiteral, DateLiteral)90%n/a111111
secToTime(DoubleLiteral)90%n/a111111
day(DateV2Literal)80%n/a111111
day(DateTimeV2Literal)80%n/a111111
fromMilliSecond(BigIntLiteral)80%n/a111111
second(TimeV2Literal)70%n/a111111
microsecond(DateTimeV2Literal)70%n/a111111
firstDayOfWeek(LocalDateTime)70%n/a111111
dateTrunc(DateV2Literal, StringLikeLiteral)70%n/a111111
dateTrunc(StringLikeLiteral, DateV2Literal)70%n/a111111
fromUnixTime(BigIntLiteral)70%n/a111111
fromUnixTime(DecimalLiteral)70%n/a111111
fromUnixTime(DecimalV3Literal)70%n/a111111
microsecondsDiff(DateTimeV2Literal, DateTimeV2Literal)70%n/a111111
microsecondsDiff(TimestampTzLiteral, TimestampTzLiteral)70%n/a111111
secondsDiff(DateTimeV2Literal, DateTimeV2Literal)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
daysDiff(DateLiteral, DateLiteral)70%n/a111111
microsecond(TimeV2Literal)60%n/a111111
distanceToFirstDayOfWeek(LocalDateTime)60%n/a111111
yearWeek(DateV2Literal, IntegerLiteral)60%n/a111111
yearWeek(DateTimeV2Literal, IntegerLiteral)60%n/a111111
fromMicroSecond(BigIntLiteral)60%n/a111111
dateFormat(DateTimeV2Literal, StringLikeLiteral)51878%1150%121401
toMonday(DateV2Literal)50%n/a111111
toMonday(DateTimeV2Literal)50%n/a111111
fromUnixTime(DecimalLiteral, StringLikeLiteral)50%n/a111111
fromUnixTime(DecimalV3Literal, StringLikeLiteral)50%n/a111111
yearWeek(DateV2Literal)50%n/a111111
yearWeek(DateTimeV2Literal)50%n/a111111
daysDiff(DateTimeV2Literal, DateTimeV2Literal)40%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(DateTimeV2Literal, DateTimeV2Literal)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
getSessionLocale()23093%4450%451701
timestamp(DateTimeV2Literal)20%n/a111111
static {...}131100%n/a0102301
convertTz(DateTimeV2Literal, StringLikeLiteral, StringLikeLiteral)42100%n/a0101301
unixTimestamp(DateTimeV2Literal)19100%n/a010301
quarter(DateV2Literal)14100%n/a010101
quarter(DateTimeV2Literal)14100%n/a010101
weekDay(DateV2Literal)13100%n/a010101
dayOfWeek(DateV2Literal)11100%n/a010101
dayOfWeek(DateTimeV2Literal)11100%n/a010101
hoursDiff(DateTimeV2Literal, DateTimeV2Literal)11100%n/a010101
date(DateTimeV2Literal)10100%n/a010101
toDate(DateTimeV2Literal)10100%n/a010101
dayName(DateV2Literal)10100%n/a010201
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
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
dayOfYear(DateV2Literal)7100%n/a010101
dayOfYear(DateTimeV2Literal)7100%n/a010101
week(DateTimeV2Literal, IntegerLiteral)6100%n/a010101
week(DateV2Literal, IntegerLiteral)6100%n/a010101
week(DateTimeV2Literal)5100%n/a010101
week(DateV2Literal)5100%n/a010101