BUG: ????? ??????? ?????? ??? smalldatetime "???? ????? ????"

?????? ????????? ?????? ?????????
???? ???????: 118877 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
BUG# OS/2: 1875 (4.2)
       NT:  864 (4.2)
		
????? ???? | ?? ????

???????

???? ????? ???? ??????? ?????? ??? datetime ?? ??????? ?? ????? ???? ??? ????? ??? ????? smalldatetime. ???? ??? ??? ??? ??? 11:59:30 ? 11: 59: 59 ?. ???? ????? ?????? ??? 12:00:XXam ?? ????? ??????.

??? ???? ???????
   declare @time datetime
   declare @s_time smalldatetime

   select @time = "July 26,1994 11:59:59pm"
   select convert(char(40), @time, 9)
   select @s_time = @time
   select convert(char(40), @s_time, 9)
   select convert(char(40), @time, 9)
   go
				

?? ????? ?????? ????? @ ?? "1994 26 ????? 11:59:31:000 PM" ??? "??? ?? ????? 12:00:31:000 ?."

???? ??????

??? ??? ?? ??? ?????? ?? ??? ?????? ? ?????? ??? ?????/??? ????? ?? ??????? smalldatetime ???.

?????

???? Microsoft ?? ???? ????? ?? Microsoft SQL Server ??????? 4.2 ???. ??? ??? researching ??? ??????? ?? ???? ??? ???? ????????? ??? ?? "????? ??????? ?? Microsoft ??? ?? ???? ??????.

???????

???? ???????: 118877 - ????? ??? ??????: 14/???? ??????/1435 - ??????: 1.1
????? ???
  • Microsoft SQL Server 4.21a Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbprogramming KB118877 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????118877

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com