这个sql statement该如何写(mysql)

如果database 里的datafield "submit_date" 的value是这样的
"2005-07-15 14:33:15"

我想得到所有是[今天的日期]的资料的sql statement 该如何写

p/s: 我使用mysql database 的！！

SELECT * FROM order WHERE submit_date = ？？

miao1978

原帖由 kengkit 于 15-7-2005 03:42 PM 发表
如果database 里的datafield "submit_date" 的value是这样的
"2005-07-15 14:33:15"

我想得到所有是[今天的日期]的资料的sql statement 该如何写

p/s: 我使用mysql database 的！！
...

SELECT * FROM ORDER WHERE submit_date >= '2005-07-15 '

fannwong

我会用microsoft SQL SERVER 2000，你可以试一下
如果是从microsoft SQL SERVER 2000 从retrieve result,那应该是这样

select submit_date from 'write your table name' where DATEPART(YEAR,submit_date)='2005'and DATEPART(MONTH,submit_date)='07' and DATEPART(DAY,submit_date)='15'

如果你要从program retrieve data,like use VB.NET to retrieve database data,then it should be like that


VB.NET code
"select submit_date from 'write your table name' where DATEPART(YEAR,submit_date)='" & system.datetime.now.year & "' & "and DATEPART(MONTH,submit_date)='" & system.datetime.now.month & "' & "and DATEPART(DAY,submit_date)='" & system.datetime.now.day & "'"

flashang

SELECT *
FROM `TABLE`
WHERE DATE( submit_date ) = DATE( NOW( ) )

thx a lot.. i solved my problem liao