Dylan, how 'bout a little code so we can see what you're trying to do? SQL Server has a datetime (and a smalldatetime) data type. You can define a column in your db and a parameter in a stored proc of that type, pass it a date (in date format, Tore will tell you, use CDate if necessary in your ASP code) and it can insert it in the db. SQL Server also has a function getdate() which returns the current date, and your proc can compare the input parameter to getdate() and act accordingly. Does this help? If not, send more info and some code.
HTH -----Original Message----- From: Chris Tifer [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:25 PM To: ActiveServerPages Subject: Re: SQL and dates in a page Are you calling a stored procedure? Do you mean you don't know what type of parameter you should define it as? I always use adDate If that's not what you're talking about, you might need to explain a little further. Chris Tifer http://www.emailajoke.com ----- Original Message ----- From: "Dylan Barber" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 5:45 AM Subject: SQL and dates in a page I have a news script that inserts a news item into a database (MS SQL server 2000) the table has a release date field that I want to check against the current date. Sounds simple right. However I can not figure out how to submit a datetime to the Database so Right now I can't check the date can anybody help me? __________________________________________________ Dylan Barber (CIW Professional, A+ Technician) Programmer/Analyst DPRA Inc. phone (785) 539-3565 ext.1034 e-mail [EMAIL PROTECTED] --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
