C# DATETIME MYSQL COMMAND

jayprakash sharma

Total Post:117

Points:821
Posted by  jayprakash sharma
C# 
C#
 2226  View(s)
Ratings:
Rate this:

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?

  1. Pravesh Singh

    Post:412

    Points:2888
    Re: C# DateTime MySQL Command

    Hi jayPrakash,

    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")+"'";

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!