在c#中
DateTime dt1 = this.dateTimePicker1.Value;
string startTime1 = dt1.ToString("yyyy-MM-dd HH:mm:ss");
string startTime2 = dt1.ToString("yyyyMMddHHmmss");
返回结果值分别为:
startTime1 "2016-12-14 22:38:14" string
startTime2 "20161214223814" string
其他时间日期格式转换参考:http://www.cnblogs.com/polk6/p/5465088.html
http://blog.csdn.net/liyongliang2012/article/details/7866319
c#中执行string sql语句中:
根据日期时间字段,其中日期时间中有空格的解决办法:
string sql = string.Format("select * from " + tableName + " where No >= ( select top(1) No from " + tableName + " where DateTime >= '{0}' ) and No< (select top(1) No from " + tableName + " where DateTime > '{1}' )",startTime,endTime);
这样可以保证c#中sql语句的正常执行。