摘要:
DateTime.Now.AddDays(10).ToShortDateString().ToString() addDays(整数) 一天前DateTime.Now.AddDays(-1).ToShortDateString().ToString() 一天后DateTime.Now.AddDays 阅读全文
posted @ 2016-12-06 18:19 灵犀ING 阅读(307) 评论(0) 推荐(0)
|
|
|
|
摘要:
DateTime.Now.AddDays(10).ToShortDateString().ToString() addDays(整数) 一天前DateTime.Now.AddDays(-1).ToShortDateString().ToString() 一天后DateTime.Now.AddDays 阅读全文
posted @ 2016-12-06 18:19 灵犀ING 阅读(307) 评论(0) 推荐(0)
摘要:
使用unix_timestamp方法进行比较,将字符型的时间,转成unix时间戳 select * from t1 where unix_timestamp(time1) > unix_timestamp('2011-03-03 17:39:05') and unix_timestamp(含有时间的 阅读全文
posted @ 2016-12-06 18:16 灵犀ING 阅读(10898) 评论(0) 推荐(0) |
|