select * from accounts where duedate<=convert(float,getdate())
- Original Message -
From: "Chuck PUP Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 12:31 PM
Subject: Date and SQL statement
> I need to do a search where I
On Wednesday, 20. March 2002 18:31, Chuck PUP Payne wrote:
Hi!
> I need to do a search where I am looking at the table that has dates and I
> need to look only things that are 30 days or younger.
>
> Can so one show me a some SQL statements where you use < , >? And the key
> for equal to or less?
I need to do a search where I am looking at the table that has dates and I
need to look only things that are 30 days or younger.
Can so one show me a some SQL statements where you use < , >? And the key
for equal to or less?
Chuck Payne
Magi Design
-
