typeCoercion/native/dateTimeOperations.sql

0001 --
0002 --   Licensed to the Apache Software Foundation (ASF) under one or more
0003 --   contributor license agreements.  See the NOTICE file distributed with
0004 --   this work for additional information regarding copyright ownership.
0005 --   The ASF licenses this file to You under the Apache License, Version 2.0
0006 --   (the "License"); you may not use this file except in compliance with
0007 --   the License.  You may obtain a copy of the License at
0008 --
0009 --      http://www.apache.org/licenses/LICENSE-2.0
0010 --
0011 --   Unless required by applicable law or agreed to in writing, software
0012 --   distributed under the License is distributed on an "AS IS" BASIS,
0013 --   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
0014 --   See the License for the specific language governing permissions and
0015 --   limitations under the License.
0016 --
0017
0018 CREATE TEMPORARY VIEW t AS SELECT 1;
0019
0020 select cast(1 as tinyint) + interval 2 day;
0021 select cast(1 as smallint) + interval 2 day;
0022 select cast(1 as int) + interval 2 day;
0023 select cast(1 as bigint) + interval 2 day;
0024 select cast(1 as float) + interval 2 day;
0025 select cast(1 as double) + interval 2 day;
0026 select cast(1 as decimal(10, 0)) + interval 2 day;
0027 select cast('2017-12-11' as string) + interval 2 day;
0028 select cast('2017-12-11 09:30:00' as string) + interval 2 day;
0029 select cast('1' as binary) + interval 2 day;
0030 select cast(1 as boolean) + interval 2 day;
0031 select cast('2017-12-11 09:30:00.0' as timestamp) + interval 2 day;
0032 select cast('2017-12-11 09:30:00' as date) + interval 2 day;
0033
0034 select interval 2 day + cast(1 as tinyint);
0035 select interval 2 day + cast(1 as smallint);
0036 select interval 2 day + cast(1 as int);
0037 select interval 2 day + cast(1 as bigint);
0038 select interval 2 day + cast(1 as float);
0039 select interval 2 day + cast(1 as double);
0040 select interval 2 day + cast(1 as decimal(10, 0));
0041 select interval 2 day + cast('2017-12-11' as string);
0042 select interval 2 day + cast('2017-12-11 09:30:00' as string);
0043 select interval 2 day + cast('1' as binary);
0044 select interval 2 day + cast(1 as boolean);
0045 select interval 2 day + cast('2017-12-11 09:30:00.0' as timestamp);
0046 select interval 2 day + cast('2017-12-11 09:30:00' as date);
0047
0048 select cast(1 as tinyint) - interval 2 day;
0049 select cast(1 as smallint) - interval 2 day;
0050 select cast(1 as int) - interval 2 day;
0051 select cast(1 as bigint) - interval 2 day;
0052 select cast(1 as float) - interval 2 day;
0053 select cast(1 as double) - interval 2 day;
0054 select cast(1 as decimal(10, 0)) - interval 2 day;
0055 select cast('2017-12-11' as string) - interval 2 day;
0056 select cast('2017-12-11 09:30:00' as string) - interval 2 day;
0057 select cast('1' as binary) - interval 2 day;
0058 select cast(1 as boolean) - interval 2 day;
0059 select cast('2017-12-11 09:30:00.0' as timestamp) - interval 2 day;
0060 select cast('2017-12-11 09:30:00' as date) - interval 2 day;