Re: date format

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: kishor (kishor_at_discussions.microsoft.com)
Date: 06/23/04


Date: Wed, 23 Jun 2004 03:10:01 -0700

Yes that is true... but how do I agin convert it back to date time... my question confusing ...

I have a sp which has two parameters one is fromdate and todate. Both having datatype datetime. But whenever I am executing the query thro’ code I have a problem (in analyzer I don’t have a problem ). Then I found there is change in format. if in a date, if I have a character ‘/’ query is not executing. Do you have any suggestions as I don’t want to change the front-end code.

TIA ,
Kishor