从bigquery上的字符串格式从时间戳提取小时
我有一个以字符串格式的时间戳，看起来像2010-02-02T07：54：40Z。如何从此时间戳获取小时？
我尝试了选择DT，从表中提取（从DT提取），但是我遇到了此错误：
No matching signature for function EXTRACT for argument types: DATE_TIME_PART FROM STRING. Supported signatures: EXTRACT(DATE_TIME_PART FROM DATE); EXTRACT(DATE_TIME_PART FROM TIMESTAMP [AT TIME ZONE STRING]); EXTRACT(DATE_TIME_PART FROM DATETIME); EXTRACT(DATE_TIME_PART FROM TIME); EXTRACT(DATE_TIME_PART FROM INTERVAL)
如何从hour中获取2010-02-02-02T07： 54：40Z？
I have a timestamp that is in the string format that looks like 2010-02-02T07:54:40Z. How can I get the HOUR from this timestamp?
I tried SELECT dt, EXTRACT(HOUR FROM dt) FROM table but I am getting this error:
No matching signature for function EXTRACT for argument types: DATE_TIME_PART FROM STRING. Supported signatures: EXTRACT(DATE_TIME_PART FROM DATE); EXTRACT(DATE_TIME_PART FROM TIMESTAMP [AT TIME ZONE STRING]); EXTRACT(DATE_TIME_PART FROM DATETIME); EXTRACT(DATE_TIME_PART FROM TIME); EXTRACT(DATE_TIME_PART FROM INTERVAL)
How do I get the HOUR from 2010-02-02T07:54:40Z?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先，您需要将字符串作为时间戳施放，然后需要提取小时。
我在项目中复制了问题，这是解决方案。
查询部分 - （TS_STRING是带有字符串数据类型的列名）
提取（小时
从
铸造（TS_STRING作为时间戳））AS hour_extract
First you need to cast string as timestamp and then need to extract hour.
I have replicated issue in my project and here is the solution.
Query part- ( ts_string is column name with string datatype)
EXTRACT(hour
FROM
CAST(ts_string AS timestamp)) AS hour_extracted