-- 1、查询2005年以前出版的书籍信息。
select *
from books where PublishDate < Convert(DateTime, '2005-1-1')select *
from books where PublishDate < Cast('2005-1-1' As DateTime)-- 2、查询2005年和2006年之间出版的书籍。
Select *
From Books
Where PublishDate >= '2005-1-1'
and PublishDate <= '2006-12-31'一个转换了,一个没转。。到底应该采用哪种?
select *
from books where PublishDate < Convert(DateTime, '2005-1-1')select *
from books where PublishDate < Cast('2005-1-1' As DateTime)-- 2、查询2005年和2006年之间出版的书籍。
Select *
From Books
Where PublishDate >= '2005-1-1'
and PublishDate <= '2006-12-31'一个转换了,一个没转。。到底应该采用哪种?
From Books
Where PublishDate between '2005-1-1' and '2006-12-31'
From Books
Where PublishDate between '2005-1-1 00:00:00' and '2006-12-31 23:59:59'
select *
from books where PublishDate < Convert(DateTime, '2005-1-1') select *
from books where PublishDate < Cast('2005-1-1' As DateTime)
select *
from books where year(PublishDate) < 2005
-- 2、查询2005年和2006年之间出版的书籍。
Select *
From Books
Where PublishDate >= '2005-1-1'
and PublishDate <= '2006-12-31' Select *
From Books
Where year(PublishDate) between 2005 and 2006