Dates Problem - MS SQL

[Tryst]

Hi all, I have a problem when in one table I have dates in the following format, 2004-11-06 18:00:00.000, and in another table I have the date in this format, 2004-10-11 13:00:00.000.

The problem here is that I have the Month and day values in different order (11 (Nov) represents the month values in the above examples), and as I am using the DATEDIFF function to determine the time difference between the date I am coming up with incorrect data.

Is there a way I can get around this?

Thanks

Tryst

[hgilbert]

this is strange
i thought that DateFormat would be consistent throughout the database
either American or British.

you'd have to set the property of both tables to comply to the same formatting
how to achieve that - i would have to reseach it myself - I'll try.

[r937]

tryst, dates are stored internally as integers, eg 36175

what you are seeing is the default display format

when you do date arithmetic, like DATEDIFF, the expressions are evaluated using the internal formats

can you give examples of invalid results?

[Tryst]

Hi all,

the problem has now been resolved.

Its seems I was stored one date as a NVARCHAR data type, and another as an actual DATETIME data type. My fault

Thanks

Tryst