MySql(Date、DateTime、TimeStamp等):
方法壹:直接比較
select * from test where create_time between ‘2015-03-03 17:39:05’ and ‘2016-03-03 17:39:52’;
方法二:用unix_timestamp函數,將字符型的時間,轉成unix時間戳
select * from test where unix_timestamp(create_time) >
unix_timestamp(‘2011-03-03 17:39:05’) and unix_timestamp(create_time)
< unix_timestamp(‘2011-03-03 17:39:52’);
個人覺得這樣比較更踏實點兒。
Oracle(Date,TimeStamp等):
方法壹:將字符串轉換為日期類型
select * from test where create_time between to_date(‘2015-03-03 17:39:05’) and to_date(‘2016-03-03 17:39:52’);
二.存儲日期類型的字段為數值類型
MySql(bigint):
方法壹:將日期字符串轉換為時間戳
select * from test where create_time > unix_timestamp(‘2011-03-03
17:39:05’) and create_time< unix_timestamp(‘2011-03-03 17:39:52’);
方法二:將時間戳轉換為日期類型
select * from test where from_unixtime(create_time/1000) between ‘2014-03-03 17:39:05’ and ‘2015-03-03 17:39:52’);