Com agafar la data i la hora de dos camps diferents en una consulta SQL

 

SELECT        Data, hora, CONVERT(varchar(10), Data, 103) AS Expr2, CONVERT(varchar(8), hora, 108) AS Expr3, CONVERT(datetime, CONVERT(varchar(10), Data, 103) + ' ' + CONVERT(varchar(8), hora, 108), 103)

                         AS Expr1

FROM            Moviments

ORDER BY Expr1

Etiquetas de Technorati: SQL,SQLServer,Data,Hora