|
|
|
Поясните как такое может быть
|
|||
|---|---|---|---|
|
#18+
Hi All ! MSSQL 2000(SP2), Win2000(sp3)rus не понимаю почему select номер 3 ничего не дает или почему первые два дают:( create table abc (a datetime); insert into abc(a) values('2002-11-25 18:51:23.780'); select * from abc where a='2002-11-25 18:51:23.780'; (1 row(s) affected) select * from abc where a='2002-11-25 18:51:23.781'; (1 row(s) affected) select * from abc where a='2002-11-25 18:51:23.782'; (0 row(s) affected) Как так ? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.11.2002, 19:28:20 |
|
||
|
Поясните как такое может быть
|
|||
|---|---|---|---|
|
#18+
"datetime Date and time data from January 1, 1753, to December 31, 9999, to an accuracy of one three-hundredth second, or 3.33 milliseconds. Values are rounded to increments of .000, .003, or .007 milliseconds, as shown in the table. Example Rounded example 01/01/98 23:59:59.999 1998-01-02 12:00:00.000 01/01/98 23:59:59.995, 01/01/98 23:59:59.996, 01/01/98 23:59:59.997, or 01/01/98 23:59:59.998 1998-01-01 23:59:59.997 01/01/98 23:59:59.992, 01/01/98 23:59:59.993, 01/01/98 23:59:59.994 1998-01-01 23:59:59.993 01/01/98 23:59:59.990 or 01/01/98 23:59:59.991 1998-01-01 23:59:59.990 SQL Server rejects all values it cannot recognize as dates between 1753 and 9999. smalldatetime Date and time data from January 1, 1900, through June 6, 2079, with accuracy to the minute." (c) SQL server books online ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.11.2002, 19:31:29 |
|
||
|
Поясните как такое может быть
|
|||
|---|---|---|---|
|
#18+
Код: plaintext 1. 2. 3. 4. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.11.2002, 19:31:56 |
|
||
|
|
start [/forum/topic.php?fid=46&msg=32072217&tid=1818514]: |
0ms |
get settings: |
7ms |
get forum list: |
13ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
38ms |
get topic data: |
8ms |
get forum data: |
2ms |
get page messages: |
30ms |
get tp. blocked users: |
1ms |
| others: | 193ms |
| total: | 296ms |
| 0 / 0 |
