Date type to SQL Server 2000 datetime field

[Nick]

Hi I am trying to add parameters to pass to a stored procedure in SQL
Server 2000, I am stuck on the DateTime field value. What do I need to
do in my application with the Date type field so I can pass its value
successfully to the DateTime field in SQL Server?

Thanks
Nick


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Joey Powell]

"'" + MyDateTime.ToString() "'"

or

"'" + MyDateTime.ToShortDateString() + "'"

This works in SQL INSERT statements. You just have to treat it like
text. SQL Server does the rest.

Nick <an*******@devdex.com> wrote in message news:<OW*************@TK2MSFTNGP10.phx.gbl>...

Hi I am trying to add parameters to pass to a stored procedure in SQL
Server 2000, I am stuck on the DateTime field value. What do I need to
do in my application with the Date type field so I can pass its value
successfully to the DateTime field in SQL Server?

Thanks
Nick


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Nick]

Thanks very much that is now working fine :-)
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!