DateTime Compare Problem

[dataminers]

I have sql query in C# SELECT Last_Date FROM MYTABLE WHERE Last_Date > CONVERT(DATETIME, '13.11.2007 22:43:50', 103) Note: Last_Date column data type is datetime Example; If my Last_Date column like this 13.11.2007 22:43:49 13.11.2007 22:43:50 13.11.2007 22:43:51 So this query return this values 13.11.2007 22:43:50 13.11.2007 22:43:51 If I change ">" operator to ">=" operator, result is same. How can I eleminate "13.11.2007 22:43:50" value? I want to get greater than (">") values. Thanks..

[Christian Graus]

There is a micro second component, I believe. Try 22:43:50.999

Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

[dataminers]

Yes, its true. I know but how can I solve my problem. I think this is related about style code "103". But I don't know which style code is correct my problem. I search but I can't find.

[Bino B]

First of all what u need to do AFAIK is to split the datetime into three parts lik date,time and am/pm. then put the checking.this will fetch u the xact result.

Cheers Bino www.codepal.co.nr