Hi!
Im trying to get europe time in one of my gridviews (instead of am/pm format), and tryed using following select-string:
SelectCommand="SELECT Convert(DateTime, vagt.start, 13), vagt.***, medarbejder.fornavn + ' ' + medarbejder.efternavn AS Expr1, medarbejder.medarbejder_id, vagt.vagt_id FROM vagt INNER JOIN medarbejder ON vagt.medarbejder_id = medarbejder.medarbejder_id WHERE vagt.dags_id = @intDagsid"
The thing to note ofc, is the Convert() part. Now, when i use that method on the "vagt.start" column, it gives me an error stating it cant fint a field or property with the specified name. The above select-string works fine without the Convert() method around vagt.start.
Any ideas?
...
Go to the complete details ...