def METHOD_NAME(translator: ExprTranslator, op: ops.Node) -> str:
    arg, unit = op.args
    if unit == TimestampUnit.MILLISECOND:
        return f"TO_TIMESTAMP_LTZ({helpers.quote_identifier(arg.name, force=True)}, 3)"
    elif unit == TimestampUnit.SECOND:
        return f"TO_TIMESTAMP_LTZ({helpers.quote_identifier(arg.name, force=True)}, 0)"
    raise ValueError(f"{unit!r} unit is not supported!")