Comparing dates in a stored procedure

I have a value in my database that represents an expire date.
Format is: 08/29/99.

How do I compare this to the actual date in a stored procedure?

Do I need to convert my expire date somehow before comparing it
to the value returned by getDate()?

thanks!
Dena
LVL 1
denamAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
MasseyMConnect With a Mentor Commented:
no need to convert the date you have stored...

If StoredDate > GetDate() then
  date is in the future..
End If
0
 
denamAuthor Commented:
Correction: the expire date is in a datetime datatype.
Vi6 shows it in the format above, but a sql query displays it as: Aug 29 1999 12:00AM
0
 
denamAuthor Commented:
Thanks Massey
0
All Courses

From novice to tech pro — start learning today.