SQl的时间问题。(75分)

L

LongHai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #1

我想得出某段时间之内的记录SQL如下：
SELECT　＊　FROM　TABLE1　WHERE　WRITEDATE　BETWEEN　'2002-11-05 01:01:01'　AND　
'2002-11-05 23:59:59'
我想选出2002－11－05日的记录，那上面的SQL选不出2002－11－05日的记录，有没有什么
解决方法（这句SQL可以运行，就是结果为空）

 

Z

zgdtxf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #2

确定有满足条件的记录吗？如果要查一天的记录应该从开始吧
SELECT　＊　FROM　TABLE1　WHERE　WRITEDATE　>='2002-11-05 00:00:00'　AND　
WRITEDATE　<='2002-11-05 23:59:59'
试试

 

M

misxjq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #3

SELECT　＊　FROM　TABLE1　WHERE　WRITEDATE>='2002-11-05 00:00:00'　AND　
WRITEDATE<='2002-11-05 23:59:59'
或者
SELECT　＊　FROM　TABLE1　WHERE　Year(WRITEDATE)=2002 AND Month(WRITEDATE)=11 AND
Day(WRITEDATE)=05　

 

H

HunterTeam

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #4

你用的是什么数据库，如果是ACCESS，要这么改一改：
SELECT　＊　FROM　TABLE1　WHERE　WRITEDATE　BETWEEN　'#2002-11-05 01::01::01#'　AND　
'#2002-11-05 23::59::59#'

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #5

year(writedate)='2002' and month() = and day()=

 

M

maolu28

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #6

请相信我：
SELECT　＊　FROM　TABLE1　WHERE　WRITEDATE>'2002-11-04 23:59:59'　AND　
WRITEDATE<'2002-11-06'
good luck!

 

Y

ydysn

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-07

• #7

SELECT　＊　FROM　TABLE1　WHERE　WRITEDATE　BETWEEN　convert(smalldate,'2002-11-05 01:01:01')　AND　
convert(smalldate,'2002-11-05 23:59:59')