为什么在使用 Union All 和强制转换函数时出现错误？

发布于 2025-01-15 14:33:34 字数 789 浏览 0 评论 0原文

我正在使用 union all 将不同的数据表组合在一起。在最后一行中，ride_length 是字符串类型，因此我决定使用强制转换函数将其更改为时间函数。

我收到一个错误：

无效的时间字符串“24:59:55”

SELECT ride_id, rideable_type, started_at,ended_at,ride_length,day_of_week,start_lat, start_lng, end_lat, end_lng, member_casual  
 FROM `cyclistic-case-study-340816.2021_11.nov` 

 UNION ALL 
 SELECT ride_id, rideable_type, started_at,ended_at,ride_length,day_of_week,start_lat, start_lng, end_lat, end_lng, member_casual  
 FROM `cyclistic-case-study-340816.2021_12.dec` 
 UNION ALL 

 SELECT ride_id, rideable_type, started_at,ended_at,CAST(ride_length AS TIME) AS ride_length,day_of_week,start_lat, start_lng, end_lat, end_lng, member_casual  
 FROM `cyclistic-case-study-340816.2021_01.jan`

原文

I'm using union all to combine different data tables together. In the last line, the ride_length is a string type so I decided to use the cast function to change it to a time function.

I received an error:

Invalid time string "24:59:55"

SELECT ride_id, rideable_type, started_at,ended_at,ride_length,day_of_week,start_lat, start_lng, end_lat, end_lng, member_casual  
 FROM `cyclistic-case-study-340816.2021_11.nov` 

 UNION ALL 
 SELECT ride_id, rideable_type, started_at,ended_at,ride_length,day_of_week,start_lat, start_lng, end_lat, end_lng, member_casual  
 FROM `cyclistic-case-study-340816.2021_12.dec` 
 UNION ALL 

 SELECT ride_id, rideable_type, started_at,ended_at,CAST(ride_length AS TIME) AS ride_length,day_of_week,start_lat, start_lng, end_lat, end_lng, member_casual  
 FROM `cyclistic-case-study-340816.2021_01.jan`

分享到QQ

分享到微博