urgent: how to compare two dates in SQL? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

urgent: how to compare two dates in SQL?

urgent: how to compare two dates in SQL?# Database - 数据库

S*n2000-04-01 08:04

1 楼

I tried to do
"SELECT * FROM user WHERE made_time > " + login
in ASP. login is a variant, do I need single quote?
Error message:
Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
criteria expression.
What's wrong?

w*h2000-04-01 08:04

2 楼

What's the data type of your made_time? Andwhat's the format
of "login"? They have to be consistent.

【在 S****n 的大作中提到】

: I tried to do
: "SELECT * FROM user WHERE made_time > " + login
: in ASP. login is a variant, do I need single quote?
: Error message:
: Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
: criteria expression.
: What's wrong?

i*s2000-04-01 08:04

3 楼

Use cdate() change login to data type

【在 S****n 的大作中提到】

w*n2000-04-01 08:04

4 楼

Or, simply use SYSDate instead of 'login'.
I think it can also works.

【在 S****n 的大作中提到】

b*e2000-04-01 08:04

5 楼

if login is a date variable that is specified by user at
runtime.. you should make sure you add ' ' around login
in the variable itself.. then construct your sql.

【在 w*********n 的大作中提到】

: Or, simply use SYSDate instead of 'login'.
: I think it can also works.