Re: date format
From: kishor (kishor_at_discussions.microsoft.com)
Date: 06/23/04
- Next message: David Portas: "Re: Help me designing that please"
- Previous message: Keith: "Re: Trigger Error"
- In reply to: Hari: "Re: date format"
- Next in thread: Tibor Karaszi: "Re: date format"
- Reply: Tibor Karaszi: "Re: date format"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: David Portas: "Re: Help me designing that please"
- Previous message: Keith: "Re: Trigger Error"
- In reply to: Hari: "Re: date format"
- Next in thread: Tibor Karaszi: "Re: date format"
- Reply: Tibor Karaszi: "Re: date format"
- Messages sorted by: [ date ] [ thread ]