now()函数如何在这里设置? ( 积分: 50 )

E

elegantok

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-23

• #1

sql ="select * from data where 日期='now()'"
在javascript 中 我想把日期 取现在的时间 ,格式是 2007-9-23 ,我应该如何处理这段代码?

 

B

bjaman

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-23

• #2

sql ='select * from data where 日期=' + QuotedStr(DateTemeToStr(Now))

 

E

elegantok

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-23

• #3

不对啊,编译不过去,帮忙看看日期后面带的now应该怎么表示?

 

E

elegantok

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-09-23

• #4

直接贴上代码
<%
dsntemp=&quot;driver={microsoft access driver (*.mdb)};&quot;
dsntemp=dsntemp &amp;
&quot;dbq=&quot;
&amp;
server.mappath(&quot;data/birthday.mdb&quot
set conn=server.createobject(&quot;adodb.connection&quot
conn.open dsntemp
sql =&quot;select * from data where 日期=Now()&quot;
set rs=server.createobject(&quot;adodb.recordset&quot
rs.open sql,conn,1,1
%>

日期处我想取 月和日 格式如:9-23
我应该如何处理?

 

P

programsky

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-07

• #5

引号是表示字符串的,当然不能把函数放在里面

 

S

songrun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-07

• #6

數據庫端的表示方式吧！或者二樓

 

X

xingkong97

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-07

• #7

sql ='select * from data where 日期=' + QuotedStr(DateTemeToStr(Now()))

 

4

41426277

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-07

• #8

sql ='select * from data where 日期=' + QuotedStr(DateTemeToStr(Now())) //这单词DateTemeToStr有错
应DateTimeToStr

 

Z

zhengjp

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-11-07

• #9

格式 2007-9-23: convert(char(10),getdate(),126)
格式:9-23 :convert(char(5),getdate(),110)
说明：126和110为style