合并日期、命中.小时和命中.分钟字段

Question

我想结合日期，hout.hour＆amp;命中一个小时的字段进入一个日期场，可以通过Tableau轻松读取以进行可视化。

日期是字符串和命中。hour＆amp;hits.minute是整数。

最后日期应该像yyyy-mm-dd＆amp;HH：mm。

atm我将日期转换为字符串，但我不知道如何将字段组合起来，或者通常是第一步是否正确。

最好，帕斯卡尔

SELECT 
fullVisitorId,
visitId,
date,
CAST (hits.hour as string) AS hour,
CAST (hits.minute as string) AS minute,
totals.transactions ,
hits.item.productName,
FROM [X.ga_sessions_20180221] 
WHERE hits.hitNumber =1
GROUP BY 
  fullVisitorId, visitId, date, hour, minute, hits.item.productName, totals.transactions

Answer 1

您只需要连接选定的值

SELECT 
    fullVisitorId,
    visitId,
    CAST(date as string) +' & ' + CAST (hits.hour as string) + ':' + CAST (hits.minute as string) AS datetime,
    totals.transactions ,
    hits.item.productName,
FROM [X.ga_sessions_20180221] 
WHERE 
    hits.hitNumber =1
GROUP BY 
  fullVisitorId, visitId, date, hour, minute, hits.item.productName, totals.transactions