io.trino.operator.scalar.time.LocalTimeFunction Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of trino-main Show documentation

Trino - Engine

There is a newer version: 465

/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package io.trino.operator.scalar.time;

import io.trino.spi.connector.ConnectorSession;
import io.trino.spi.function.LiteralParameter;
import io.trino.spi.function.LiteralParameters;
import io.trino.spi.function.ScalarFunction;
import io.trino.spi.function.SqlNullable;
import io.trino.spi.function.SqlType;

import java.time.LocalDateTime;

import static io.trino.spi.type.TimeType.MAX_PRECISION;
import static io.trino.type.DateTimes.PICOSECONDS_PER_DAY;
import static io.trino.type.DateTimes.PICOSECONDS_PER_NANOSECOND;
import static io.trino.type.DateTimes.round;

@ScalarFunction(value = "$localtime", hidden = true)
public final class LocalTimeFunction
{
    private LocalTimeFunction() {}

    @LiteralParameters("p")
    @SqlType("time(p)")
    public static long localTime(
            @LiteralParameter("p") long precision,
            ConnectorSession session,
            @SqlNullable @SqlType("time(p)") Long dummy) // need a dummy value since the type inferencer can't bind type arguments exclusively from return type
    {
        long nanos = LocalDateTime.ofInstant(session.getStart(), session.getTimeZoneKey().getZoneId())
                .toLocalTime()
                .toNanoOfDay();

        long picos = nanos * PICOSECONDS_PER_NANOSECOND;
        return round(picos, (int) (MAX_PRECISION - precision)) % PICOSECONDS_PER_DAY;
    }
}