MsSql-MySql 날짜 비교

MySql

select estate, contentid

from flist

where convert(ctime+0, char(10)) between '2014082709' and '2014082723'

order by contentid desc

limit 0,200

MsSql

select top 1000 *

from info_file with(nolock)

where convert(varchar(8), reg_date, 112) between '20140827' and '20140827' 

order by reg_date desc