By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,810 Members | 818 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,810 IT Pros & Developers. It's quick & easy.

converting char date value in date value

P: 1
hi i am facing a strange problem
i am trying to build report using sql server 2005 and microsoft visual studio2005
now it is in requirement that i should seperate date from time.I have done that using visual studio with following code on one of the dataset values with the help of following code
SELECT Convert(varchar, Deliverydate, 103) as displayValue FROM TimePeriodOrderDeliveryDate.This only dispalys the date part from the ate time section.but there is other problem and that is when i try to use theresult of this data set in other data set then it gives me the error that
an error occurred during report processing that it can not read next row from the dataset(the one from which i am trying to read)
the conversion of char data type to small data type resulted in out of range smalldate time value.In short my problem is that i have converted oly the date part of date time part in char value and i want to convert it again into datetime value for comparison with the column values of a table and i dont know how to do it
can anybody help me please
Jun 18 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.