laxwrestler27
July 11th, 2008, 03:17 AM
I have a tableadapter in Visual Studio with the following select statement
"
SELECT rs.RouteScheduleID, rs.RouteID, (@Today - INTERVAL MOD(DATEDIFF(@Today, rs.StartDate), rs.Recurrence) DAY) AS LastScheduledDate...."
The results come out fine in the direct MYSQL command line client. But in the preview box it shows a bunch of red x's for each row under the LastScheduledDate column. When I access the data in my program it is a byte[]. The actual select statement should produce a datetime, so how can I access it as a datetime?
Thanks in advance
Edit/Delete Message
"
SELECT rs.RouteScheduleID, rs.RouteID, (@Today - INTERVAL MOD(DATEDIFF(@Today, rs.StartDate), rs.Recurrence) DAY) AS LastScheduledDate...."
The results come out fine in the direct MYSQL command line client. But in the preview box it shows a bunch of red x's for each row under the LastScheduledDate column. When I access the data in my program it is a byte[]. The actual select statement should produce a datetime, so how can I access it as a datetime?
Thanks in advance
Edit/Delete Message