c# - MySql 中的日期时间

Question

尝试使用 C# 从 MySql DB 获取数据。表中数据类型“DATE”的列值类似于“10/11/2014 12:00:00 AM”。但我只想有 10/11/2014(或 2014-10-11)

但这不起作用。

Select CAST(DumpDate AS DATE), ResourceName, Sum(ActualEffort) 
from Timesheet_Data  where dumpdate >= '2014-10-11' 
group by DumpDate, ResourceName

这也不起作用 - 选择日期(DumpDate)

结果值仍然是“10/11/2014 12:00:00 AM”。

我无权访问此数据库，因此无法检查该列是日期、varchar 还是日期时间。根据给定的文档，它说“DumpDate”的数据类型是“日期”。

C#:

private static DataTable GetEffortDataFromMySqlDB()
        {
            DataTable dtEffort = new DataTable();
            try
            {

                string CmdText = "select CAST(DumpDate AS DATE), ResourceName, 
                                  Sum(ActualEffort) from Timesheet_Data  where  
                                  dumpdate >= '2014-10-11' group by DumpDate, 
                                  ResourceName";
           DataSet ds = MySqlHelper.ExecuteDataset(BaseDB.MySqlConnectionString, 
                        CmdText);
                dtEffort = ds.Tables[0];                

            }
            catch (Exception ex)
            {

            }
            return dtEffort;
        }

Answer 1

Select DATE_FORMAT(DumpDate, '%D/%m/%Y') AS theDate, ResourceName, Sum(ActualEffort) 
from Timesheet_Data  where dumpdate >= '2014-10-11' 
group by DumpDate, ResourceName

或者

Select DATE_FORMAT(DumpDate, '%Y-%m%-d') AS theDate, ResourceName, Sum(ActualEffort) 
from Timesheet_Data  where dumpdate >= '2014-10-11' 
group by DumpDate, ResourceName