SQL Server CONVERT() º¯Êý
ÔÎijö´¦£ºhttp://www.dingos.cn/index.php?topic=1874.0
¶¨ÒåºÍÓ÷¨
CONVERT() º¯ÊýÊÇ°ÑÈÕÆÚת»»ÎªÐÂÊý¾ÝÀàÐ͵ÄͨÓú¯Êý¡£
CONVERT() º¯Êý¿ÉÒÔÓò»Í¬µÄ¸ñʽÏÔʾÈÕÆÚ/ʱ¼äÊý¾Ý
Óï·¨
CONVERT(data_type(length),data_to_be_converted,style)
data_type(length) ¹æ¶¨Ä¿±êÊý¾ÝÀàÐÍ£¨´øÓпÉÑ¡µÄ³¤¶È£©¡£data_to_be_converted º¬ÓÐÐèҪת»»µÄÖµ¡£style ¹æ¶¨ÈÕÆÚ/ʱ¼äµÄÊä³ö¸ñʽ¡£
¿ÉÒÔʹÓÃµÄ style Öµ£º
Style ID
Style ¸ñʽ
100 »òÕß 0
mon dd yyyy hh:miAM £¨»òÕß PM£©
101
mm/dd/yy
102
yy.mm.dd
103
dd/mm/yy
104
dd.mm.yy
105
dd-mm-yy
106
dd mon yy
107
Mon dd, yy
108
hh:mm:ss
109 »òÕß 9
mon dd yyyy hh:mi:ss:mmmAM£¨»òÕß PM£©
110
mm-dd-yy
111
yy/mm/dd
112
yymmdd
113 »òÕß 13
dd mon yyyy hh:mm:ss:mmm(24h)
114
hh:mi:ss:mmm(24h)
120 »òÕß 20
yyyy-mm-dd hh:mi:ss(24h)
121 »òÕß 21
yyyy-mm-dd hh:mi:ss.mmm(24h)
126
yyyy-mm-ddThh:mm:ss.mmm£¨Ã»Óпոñ£©
130
dd mon yyyy hh:mi:ss:mmmAM
131
dd/mm/yy hh:mi:ss:mmmAM
ʵÀý
ÏÂÃæµÄ½Å±¾Ê¹Óà CONVERT() º¯ÊýÀ´ÏÔʾ²»Í¬µÄ¸ñʽ¡£ÎÒÃǽ«Ê¹Óà GETDATE() º¯ÊýÀ´»ñµÃµ±Ç°µÄÈÕÆÚ/ʱ¼ä£º
view plaincopy to clipboardprint?
CONVERT(VARCHAR(19),GETDATE())
CONVERT(VARCHAR(10),GETDATE(),110)
CONVERT(VARCHAR(11),GETDATE(),106)
CONVERT(VARCHAR(24),GETDATE(),113)
½á¹ûÀàËÆ£º
Dec 29 2008 11:45 PM
12-29-2008
29 Dec 08
29 Dec 2008 16:25:46.635
Ïà¹ØÎĵµ£º
²¿ÃŽṹ
Id name parentId
-----------------
1 ÈËʲ¿ 0
2
¿ª·¢²¿ 1
3 ·þÎñ²¿ 1
Óû§½á¹¹
Id name departId
--------------------
101
ÕÅÈý 2
102 ÀîËÄ 2
103 ÍõÎå 3
ÏëµÃµ½
ID name
parentId
-------------------
1 ÈËʲ¿ 0
2 ¿ª·¢²¿ 1
101
ÕÅ ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Collections;
using System.Data.SqlClient;
/// <summary>
/// Êý¾Ý¿âµÄͨÓ÷ÃÎÊ´úÂë
/// ´ËÀàΪ³éÏóÀ࣬²»ÔÊÐíʵÀý»¯£¬ÔÚÓ¦ÓÃʱֱ½Óµ÷Óü´¿É
/// </summary>
public ab ......
ʹÓÃHIBERNATEµÄSQL²éѯ²¢½«½á¹û¼¯×Ô¶¯×ª»»³ÉPOJO
ÎÄÕ·ÖÀà:Java±à³Ì
ÔÚijЩ³¡ºÏÏ£¬ÎÒÃÇ¿ÉÄÜÏëʹÓÃHIBERNATEµÄ¿ò¼ÜÌṩµÄSQL²éѯ½Ó¿Ú£¬Õâʱ£¬ÓÉÓÚ±íºÍʵÌ嶼¿ÉÄÜûÓÐ×öÓ³É䣬HIBERNATE²»Äܰѽá¹û¼¯×ª»»
³ÉÄãÏëÒªµÄList<POJO>£¬±¾ÎÄÌÖÂÛÈçºÎÔÚÕâÖÖÇé¿öÏÂÈÃHIBERNATEÖ±½Ó·µ»ØÄãÏëµÄ½ ......
ÅäÖÃÔ´³ÌÐò
¸½¼ÓÊý¾Ý¿âSQL Server 2005
£¨1£©½«TM\01\App_DataÎļþ¼ÐÖеÄdb_SIS.mdfºÍdb_SIS_log.ldfÎļþ¿½±´µ½SQL Server 2005°²×°Â·¾¶ÏµÄMSSQL.1\MSSQL\DataĿ¼Ï¡£
£¨2£©Ñ¡Ôñ¿ªÊ¼/³ÌÐò/Microsoft SQL Server 2005/SQL Server Management StudioÏ½øÈëµ½“Á¬½Óµ½·þÎñÆ÷”Ò³Ã棬Èçͼ1.1Ëùʾ¡£
ͼ1.1&nbs ......
¹úÍâ¿Õ¼äòËƶÔÖÐÎıȽϸÐð Èç¹ûÊý¾ÝÀàÐÍÉè¼ÆΪ varchar ÀàÐ͵Ļ° ´æ´¢µÄÊý¾Ý»ù±¾ÉÏÊÇ "£¿£¿£¿£¿"
ºÜ¼òµ¥ ½« varchar ÀàÐÍ Éè¼ÆΪ nvarchar ÀàÐÍ
create table cs
(
txt1 nvarchar(50) null
)
insert into cs (txt1 ) values ('²âÊÔ') -- Èë¿âʱÊý¾Ýʱ £¿£¿£¿£¿
insert into cs (txt ......