i am facing problem In sql 2000 . I want to get date value with miliseconds or microseconds upto 6 digits.
I am comparing two date to avoid duplicate records

i stuck up on this point

Please somebody help me asap

Thanks [/font=Verdana][/size=4]

ashish

The DateTime datatype in SQL Server is stored as an 8 byte integer value. 4 bytes of this are used to represent the time of day as the number of milliseconds since midnight. It is accurate to 3.33 milliseconds, and values are rounded to the (roughly) nearest 3 milliseconds (0, 3, or 7).

You can't change this.

You'll have to use some other way to distingush data rows, say by using an identity column which will guarantee unique values, no matter how fast your data arrives.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hey Jeff

Thanks a Lot for your Reply. Ok means as per your statement we can not get miliseconds or microseconds in SQL syntax .

but do you have any other logic by which i can avoid diplicates records.

Example:
i have two records like this
'03/23/2006 12:31:38:536'
'03/23/2006 12:31:38:536'

How can avoid duplicate records and will get distinct results

Thanks ones

ashish



ashish

As I mentioned, if you cannot use a datetime to distingush rows because they arrive too fast for the resolution of the clock, so more than one row gets the same value, you'll have to depend upon some other form of a "uniquifier" to distingush the rows.

By far, the simplest is to use an identity column. The values are assigned by the system in a monotonicaly increasing order so you can use this value to distingush two rows with the same datetime value. Disregading some unusual circumstances, you can depend upon the fact that a row with a smaller identity value arrived "before" a row with a larger value.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com