Could someone help me with my query which go next to datatable:My query\[code\]Dim query2 As String = " select p
d as Wej?cie ,po_Do as Wyj?cie, po_NR as 'Norma Czasu pracy',po_CC as CC,po_Cp as CP,po_PPN as PPN,po_SN as SN" + " from rcp_podsumowanie inner join rcp_pracownik on po_idpracownik=pr_id" + " where pr_numerEwidencyjny = '" + TextBox1.Text + "' and pd > '" + poczatekM + "' and pd < '" + koniecM + "' and po_NR <> '0'"\[/code\]The problem is that values \[code\]po_NR as 'Norma Czasu pracy', po_CC as CC, po_Cp as CP, po_PPN as PPN, po_SN as SN\[/code\]are minutes in integer format and I want to receive them in \[code\]hh:mm\[/code\] format.Can anyone help me change my SQL query? I don't know how to use convert and I always get syntax error.
d as Wej?cie ,po_Do as Wyj?cie, po_NR as 'Norma Czasu pracy',po_CC as CC,po_Cp as CP,po_PPN as PPN,po_SN as SN" + " from rcp_podsumowanie inner join rcp_pracownik on po_idpracownik=pr_id" + " where pr_numerEwidencyjny = '" + TextBox1.Text + "' and pd > '" + poczatekM + "' and pd < '" + koniecM + "' and po_NR <> '0'"\[/code\]The problem is that values \[code\]po_NR as 'Norma Czasu pracy', po_CC as CC, po_Cp as CP, po_PPN as PPN, po_SN as SN\[/code\]are minutes in integer format and I want to receive them in \[code\]hh:mm\[/code\] format.Can anyone help me change my SQL query? I don't know how to use convert and I always get syntax error.