I am having issues with using the DateTime as the parameter to work for a sql query.
Here is the query I would like :
command.CommandText = "SELECT idGameNumber FROM GameOutcome WHERE GameOutcome.gameDate = <insert DateTime game_time>";
where game_time is a DateTime object and Gameoutcome.gameDate is a DATETIME datatype.
What do I need to put on the right side of the = sign in there WHERE clause?
using DateTime string
MYSQL takes the DateTime in Following default format:
yyyy-MM-dd HH:mm:ss
so you can convert your datetime object into above format.
Try This:
command.CommandText ="SELECT idGameNumber FROM GameOutcome WHERE GameOutcome.gameDate ='"+ game_time.ToString("yyyy-MM-dd HH:mm:ss")+"'";