将Teradata sql转换为MYSQL sql [英] Conversion of Teradata sql to MYSQL sql

问题描述

我想将Teradata查询转换为MYSQL查询.

I want to convert Teradata query into MYSQL query.

START_TIME 和 END_TIME 的数据类型为TIMESTAMP(6)

Teradata查询:-

select START_TIME,END_TIME, (EXTRACT(DAY    FROM (END_TIME - START_TIME DAY(4) TO SECOND)) * 86400) from base.xyz

结果就像:-

**START_TIME, END_TIME, CALCULATED_FIELD**

9/15/2017 16:22:52.000000   9/19/2017 15:14:02.000000   259,200
7/26/2014 07:00:04.000000   7/28/2014 12:55:55.000000   172,800
6/8/2018 16:59:19.000000    6/11/2018 09:56:23.000000   172,800
10/6/2017 17:52:06.000000   10/9/2017 15:47:35.000000   172,800
7/29/2014 02:40:00.000000   7/30/2014 04:09:56.000000   86,400
7/25/2014 08:33:35.000000   7/25/2014 09:43:34.000000   0
1/6/2015 13:56:52.000000    1/6/2015 13:57:29.000000    0

请提出什么是mysql查询

Please suggest what would be mysql query

推荐答案

尝试

SELECT start_time,
       end_time,
       TIMESTAMPDIFF(DAY, start_time, end_time) * 86400
FROM base.xyz;

小提琴

这篇关于将Teradata sql转换为MYSQL sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！