You can use the SQL function "getdate()" This will give you the exact date
and time of the call and show anything in the future.
SELECT cat, promo, date1, date2
FROM promo
WHERE date2 > getdate()
----- Original Message -----
From: "Javier Flores" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, May 23, 2005 3:15 PM
Subject: Date Compare
Hi everyone!
I'm currently making a date comparation in a DBs...
SELECT cat, promo, date1, date2
FROM promo
WHERE date2 > today()
I just want to show all the the future promos, so... Any idea?
Javier
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
