I think I get what Dylan's getting at now. You can go David's route, but whenever I have a stored procedure that inserts a record, I almost always have a d_t field in that table and it's default value is getDate() so I don't have to worry about insertion.
Chris Tifer http://www.emailajoke.com ----- Original Message ----- From: "David L. Penton" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 7:07 AM Subject: RE: SQL and dates in a page > adDBTimeStamp > > Check my site for a list of the datatypes and examples of code: > > http://www.davidpenton.com/testsite/scratch/adodb.command3.asp > > and scratch root for more stuff... > > http://www.davidpenton.com/testsite/scratch/ > > David L. Penton, Microsoft MVP > JCPenney Application Specialist / Lead > "Mathematics is music for the mind, and Music is Mathematics for the > Soul. - J.S. Bach" > [EMAIL PROTECTED] > > Do you have the VBScript Docs or SQL BOL installed? If not, why not? > VBScript Docs: http://www.davidpenton.com/vbscript > SQL BOL: http://www.davidpenton.com/sqlbol > > > -----Original Message----- > From: Chris Tifer [mailto:[EMAIL PROTECTED]] > > 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]> > > 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 PROTECTED]
