Viewing 9 posts - 1 through 9 (of 9 total)
'm not clear 'm just generate the script
March 18, 2011 at 4:22 am
Hi All,
Thank you very much Kingston Dhasian for your replay.
Problem is data mismatch Some data dd/MM/yyyy format some other data's are MM/dd/yyyy format.
your query is very useful thanks a lot..
Kiruba
October 20, 2010 at 10:33 pm
Kingston Dhasian (10/20/2010)
SELECT *
FROM tbl_00001
WHERE SUBSTRING(...
October 20, 2010 at 6:49 am
Kingston Dhasian (10/20/2010)
Did you try the below query in the client's place
SELECT * FROM tbl_00001 WHERE ISDATE(uploadtime) = 0If YES. What was the data you got from the query?
its return...
October 20, 2010 at 6:31 am
Kingston Dhasian (10/20/2010)
kirubamca09 (10/20/2010)
Hi sharath.chalamgaripls did you find any solution let me know.
Your error message clearly says that there is some data in your clients...
October 20, 2010 at 6:25 am
Hi sharath.chalamgari
pls did you find any solution let me know.
October 20, 2010 at 6:14 am
steveb. (10/20/2010)
Such as what exacltly do you mean by 'it does not work...
October 20, 2010 at 5:56 am
sharath.chalamgari (10/20/2010)
Can you post some sample data from the table, so that we can check why it is not working.Which version of SQL does the client using
uploadtime format like...
October 20, 2010 at 5:51 am
uploadtime format like this 30/09/2010 05:07:09 PM
Actualy both are using SQL 2005
October 20, 2010 at 5:44 am
Viewing 9 posts - 1 through 9 (of 9 total)