1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

请教，日期判断问题。

Discussion in '后端开发' started by ppllmm888, Jul 28, 2006.

  1. ppllmm888

    ppllmm888 New Member

    Joined:
    Mar 24, 2006
    Messages:
    4
    Likes Received:
    0
    ASP+ACCESS如何判断数据库中的日期是否当前日期？

    注：数据库中的日期格式为"2006-7-28"

    我写了以下语句，但出错。
    希望高手帮我改改。

    :razz:
    PHP:

    <%
    rq=date()
    set rs=server.createobject("adodb.recordset")
            sql="select * from gogogo where data=rq"
            rs.open sql,conn,1,1
         %>
     
    #1 ppllmm888, Jul 28, 2006
  2. weifanglin

    weifanglin New Member

    Joined:
    May 25, 2006
    Messages:
    19
    Likes Received:
    0
    Where year(日期字段)=year(date()) and month(日期字段)=month(date()) and day(日期字段)=day(date())

    不用写rq=date()
     
    #2 weifanglin, Jul 28, 2006
  3. 不学无术

    不学无术 Ulysses 的元神

    Joined:
    Aug 31, 2005
    Messages:
    16,714
    Likes Received:
    39
    如果你的字段名是 rq

    sql="select * from gogogo where rq = '" & Date() & "'"
     
    #3 不学无术, Jul 31, 2006
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)