Hour and Data

[jteixeira]

In the same table i have in one column the hour and in the other the data. How can I join the 2 columns to apear in one hour and date?

[aspnetguy]

can you give us an example or some code?

[jteixeira]

Select Avarias.Maquinaid,nicname,Avarias.tipo,Avarias.Data,Avarias.horafrom Avarias INNER JOIN Maquina on maquina.maquinaid=Avarias.maquinaidGroup by Avarias.Maquinaid,nicname,Avarias.tipo,Avarias.Data,Avarias.horaOrder by Avarias.MaquinaidI Want join Avarias.Data to Avarias.hora

[pulpfiction]

SELECT Avarias.Data + ' ' + Avarias.hora AS Date from tlb_nameTry this....

[aspnetguy]

ok try this

SELECT  Avarias.Maquinaid,   nicname,   Avarias.tipo,  Avarias.Data + ', ' + Avarias.hora AS 'DateTime'FROM Avarias INNER JOIN Maquina ON maquina.maquinaid=Avarias.maquinaidGROUP BY     Avarias.Maquinaid,  nicname,  Avarias.tipo,  Avarias.Data,  Avarias.horaORDER BY Avarias.Maquinaid

[justsomeguy]

"Date" and "DateTime" might both be reserved. You might need to use a different name like "TheDate" or something.

[pulpfiction]

I tried this query in SQL Server SELECT fld_1+ ' ' + fld_2 AS dateFROM tbl_nameIt did not throw any error....but like justsomeguy mentioned might throw some error....