MsSql³£ÓÃÈÕÆÚ¸ñʽ
SQL ServerÖÐÎÄ°æµÄĬÈϵÄÈÕÆÚ×Ö¶Îdatetime¸ñʽÊÇyyyy-mm-dd Thh:mm:ss.mmm
ÀýÈç:
select getdate()
2004-09-12 11:06:08.177
ÕûÀíÁËÒ»ÏÂSQL ServerÀïÃæ¿ÉÄܾ³£»áÓõ½µÄÈÕÆÚ¸ñʽת»»·½·¨:
¾ÙÀýÈçÏÂ:
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608
select CONVERT(varchar(12) , getdate(), 111 )
2004/09/12
select CONVERT(varchar(12) , getdate(), 112 )
20040912
select CONVERT(varchar(12) , getdate(), 102 )
2004.09.12
select CONVERT(varchar(12) , getdate(), 101 )
09/12/2004
select CONVERT(varchar(12) , getdate(), 103 )
12/09/2004
select CONVERT(varchar(12) , getdate(), 104 )
12.09.2004
select CONVERT(varchar(12) , getdate(), 105 )
12-09-2004
select CONVERT(varchar(12) , getdate(), 106 )
12 09 2004
select CONVERT(varchar(12) , getdate(), 107 )
09 12, 2004
select CONVERT(varchar(12) , getdate(), 108 )
11:06:08
select CONVERT(varchar(12) , getdate(), 109 )
09 12 2004 1
select CONVERT(varchar(12) , getdate(), 110 )
09-12-2004
select CONVERT(varchar(12) , getdate(), 113 )
12 09 2004 1
select CONVERT(varchar(12) , getdate(), 114 )
11:06:08.177
Ïà¹ØÎĵµ£º
ÔÚMSSQL¹æ·¶ÖУ¬Ö§³ÖÊÂÎñǶÌ×£¬²»¹ýÔÚǶÌ×µ÷ÓÃ×Ó´æ´¢¹ý³Ìʱ£¬Òª»Ø¹öÊÂÎñ£¬Ðè°Ñ@@error´«¸ø×îÍâ²ãÊÂÎñ¡£¾ÙÀýÈçÏ£º
drop table testtb
go
create table testtb
(
id int,name varchar(2)
)
go
--×Ó¹ý³Ì
drop proc proc_insert_sub
go
create proc proc_insert_sub
@errResult int out--·µ»Ø´ ......
ÕûÀíתÌù
Ò»¡¢ÊÂÎñµÄÊôÐÔ
¡¡¡¡ÊÂÎñ¾ßÓÐacidÊôÐÔ:¼´ atomicÔ×ÓÐÔ, consistentÒ»ÖÂÐÔ, isolated¸ôÀëÐÔ, durableÓÀ¾ÃÐÔ
¡¡¡¡Ô×ÓÐÔ£ºÊÂÎñÓ¦×÷Ϊһ¸ö¹¤×÷µ¥Ôª,ÊÂÎñ´¦ÀíÍê³É£¬ËùÓеŤ×÷Ҫô¶¼ÔÚÊý¾Ý¿âÖб£´æÏÂÀ´£¬ÒªÃ´ÍêÈ«»Ø¹ö£¬È«²¿²»±£Áô
¡¡¡¡Ò»ÖÂÐÔ£ºÊÂÎñÍê³É»òÕß³·Ïúºó£¬¶¼Ó¦¸Ã´¦ÓÚÒ»ÖµÄ״̬
¡¡¡¡¸ôÀëÐÔ£º¶à¸öÊÂÎñͬ ......
DECLARE @dt1 AS datetime, @dt2 AS datetime;
SELECT @dt1 = '2008-8-4 9:36:41', @dt2 = '2008-8-2 9:33:39';
DECLARE @Days AS int, @Hours AS int, @Minutes AS int, @Seconds AS int;
SET @Seconds = DATEDIFF( second, @dt2, @dt1);
SET @Days = @Seconds / (24 * 60 * 60)
SET @Seconds = @Seconds - @Da ......
1¡¢Ã¿ÈÕ×Ô¶¯±¸·Ý
¡¡¡¡´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬½øÈ듹ÜÀí”-“Êý¾Ý¿âά»¤¼Æ»®”£¬ÔÚÓҲര¿Úµã»÷ÓÒ¼ü£¬Ñ¡Ôñ“н¨Î¬»¤¼Æ»®”£¬Æô¶¯“Êý¾Ý¿âά»¤¼Æ»®Ïòµ¼”;µã»÷“ÏÂÒ»²½” Ñ¡ÔñÐèҪά»¤µÄÊý¾Ý¿â£¬Î¬»¤ÌØÐÔÊý¾Ý¿âʱ£¬Ñ¡Ôñ×îºóÒ»¸öµ¥Ñ¡¿ò²¢¹´Ñ¡ÐèҪά»¤µÄÊý¾Ý¿âÃû³Æ;“ÏÂÒ» ......