SqlServer语句获取整点数据
if (this.cbxSql.Checked)
{
SqlSelect = "SELECT Area_Date as Area_Date,PLE as PLE FROM " + TableName + " Where PLE>=0 and (Area_Date>='" + Local_richushijian_Quxian + "' and Area_Date <='" + Local_riluoshijian_Quxian + "') and RIGHT(CONVERT(varchar(19),Area_date,120),5)='00:00' and area_code=0";
dt = Local_mysql.Select(SqlSelect);
}
else
{
SqlSelect = "SELECT Area_Date as Area_Date,PLE as PLE FROM " + TableName + " Where PLE>=0 and (Area_Date>='" + Local_richushijian_Quxian + "' and Area_Date <='" + Local_riluoshijian_Quxian + "') and substr(area_date,15,18)='00:00' and area_code=0";
dt = SQLiteHelper.ExecuteDataSet("Data Source=" + SqlLiteDBName, SqlSelect, CommandType.Text).Tables[0];
}
mysql
RIGHT(Area_date,5)='00:00'
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步