<div>
Correction: the expire date is in a datetime datatype.<br />
Vi6 shows it in the format above, but a sql query displays it as: Aug 29 1999 12:00AM
</div>


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

<div>
<div class="content wysiwyg-content">
I have a value in my database that represents an expire date.<br />
Format is: 08/29/99.<br />
<br />
How do I compare this to the actual date in a stored procedure?<br />
<br />
Do I need to convert my expire date somehow before comparing it <br />
to the value returned by getDate()?<br />
<br />
thanks!<br />
Dena
</div>
</div>


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

Comparing dates in a stored procedure

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.