Click here to Skip to main content
15,914,416 members
Home / Discussions / C#
   

C#

 
AnswerRe: throw Pin
Guffa27-May-06 12:12
Guffa27-May-06 12:12 
GeneralRe: throw Pin
Graham Nimbley27-May-06 12:53
Graham Nimbley27-May-06 12:53 
GeneralRe: throw Pin
Judah Gabriel Himango27-May-06 14:11
sponsorJudah Gabriel Himango27-May-06 14:11 
QuestionShockwaveObject Pin
mehrdadc4827-May-06 11:15
mehrdadc4827-May-06 11:15 
Questionsql weird problem Pin
JelleM27-May-06 10:45
JelleM27-May-06 10:45 
AnswerRe: sql weird problem Pin
Colin Angus Mackay27-May-06 11:15
Colin Angus Mackay27-May-06 11:15 
GeneralRe: sql weird problem Pin
JelleM27-May-06 11:26
JelleM27-May-06 11:26 
AnswerRe: sql weird problem Pin
Guffa27-May-06 12:09
Guffa27-May-06 12:09 
JelleM wrote:
So the data is EXACTLY the same (as far as I know).


The problem is that you don't know enough. Wink | ;)

The dates you are looking at cuts the time after the seconds and doesn't show the milliseconds. When you compare if two dates are equal, they have to be equal down to the last millisecond. When you take the truncated date that you see and compare it to the date in the database, they will differ by a fraction of a second, but that is enough for them not to be equal.

To get the exact time you need to make the comparision work, you have to display the date with full precision so that you get the millisecons also.

As you see, identifying records by a datetime value is not a very good method. You should use an id instead.


---
b { font-weight: normal; }

GeneralRe: sql weird problem Pin
JelleM28-May-06 0:43
JelleM28-May-06 0:43 
AnswerRe: sql weird problem Pin
Guffa28-May-06 10:55
Guffa28-May-06 10:55 
GeneralRe: sql weird problem Pin
JelleM28-May-06 11:58
JelleM28-May-06 11:58 
GeneralRe: sql weird problem Pin
JelleM28-May-06 3:58
JelleM28-May-06 3:58 
QuestionIncreasing the size of the form Pin
cshivaprasad27-May-06 9:44
cshivaprasad27-May-06 9:44 
AnswerRe: Increasing the size of the form Pin
Colin Angus Mackay27-May-06 9:48
Colin Angus Mackay27-May-06 9:48 
AnswerRe: Increasing the size of the form Pin
stancrm28-May-06 21:17
stancrm28-May-06 21:17 
QuestionC#.Net application Pin
betty_boop27-May-06 9:31
betty_boop27-May-06 9:31 
AnswerRe: C#.Net application Pin
NaNg1524127-May-06 9:34
NaNg1524127-May-06 9:34 
GeneralRe: C#.Net application Pin
Colin Angus Mackay27-May-06 9:41
Colin Angus Mackay27-May-06 9:41 
GeneralRe: C#.Net application Pin
betty_boop27-May-06 9:54
betty_boop27-May-06 9:54 
AnswerRe: C#.Net application Pin
Colin Angus Mackay27-May-06 9:47
Colin Angus Mackay27-May-06 9:47 
GeneralRe: C#.Net application Pin
betty_boop27-May-06 10:04
betty_boop27-May-06 10:04 
GeneralRe: C#.Net application Pin
Colin Angus Mackay27-May-06 10:24
Colin Angus Mackay27-May-06 10:24 
GeneralRe: C#.Net application Pin
betty_boop27-May-06 10:36
betty_boop27-May-06 10:36 
GeneralRe: C#.Net application Pin
Ravi Bhavnani27-May-06 10:42
professionalRavi Bhavnani27-May-06 10:42 
GeneralRe: C#.Net application Pin
Colin Angus Mackay27-May-06 10:46
Colin Angus Mackay27-May-06 10:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.