SparkSQL日期加减操作：年、月、日、时、分、秒 - 详细教程

对于SparkSQL，可以使用date_add和date_sub函数来进行日期的加减操作。具体的用法如下：\n\n1. 加/减1年：\n\nSELECT date_add(date_column, INTERVAL 1 YEAR) as new_date FROM table_name; \nSELECT date_sub(date_column, INTERVAL 1 YEAR) as new_date FROM table_name; \n\n\n2. 加/减1月：\n\nSELECT date_add(date_column, INTERVAL 1 MONTH) as new_date FROM table_name; \nSELECT date_sub(date_column, INTERVAL 1 MONTH) as new_date FROM table_name; \n\n\n3. 加/减1日：\n\nSELECT date_add(date_column, INTERVAL 1 DAY) as new_date FROM table_name; \nSELECT date_sub(date_column, INTERVAL 1 DAY) as new_date FROM table_name; \n\n\n4. 加/减1小时：\n\nSELECT date_add(date_column, INTERVAL 1 HOUR) as new_date FROM table_name; \nSELECT date_sub(date_column, INTERVAL 1 HOUR) as new_date FROM table_name; \n\n\n5. 加/减1分钟：\n\nSELECT date_add(date_column, INTERVAL 1 MINUTE) as new_date FROM table_name; \nSELECT date_sub(date_column, INTERVAL 1 MINUTE) as new_date FROM table_name; \n\n\n6. 加/减1秒：\n\nSELECT date_add(date_column, INTERVAL 1 SECOND) as new_date FROM table_name; \nSELECT date_sub(date_column, INTERVAL 1 SECOND) as new_date FROM table_name; \n\n\n其中，date_column为日期类型的列名，table_name为表名。根据具体的需求，选择相应的语句进行操作。