Author: Fireblast | Posted on: 10/14/2008 5:31:20 AM | Views : 298

 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 ...