DATE - ANSI-compliant date data type
TIME - ANSI-compliant time data type with variable precision
DATETIMEOFFSET - timezone aware/preserved datetime
DATETIME2 - like DATETIME, but with variable precision and large date rangeGEOMETRY - “flat earth” spatial data type
GEOGRAPHY - “round earth” spatial data type
HIERARCHYID - represents hierarchies using path enumeration model
via SQL Server 2008 Will Have 7 New Datatypes
date와 time을 드뎌(?) 제공하는군요 =_=;
댓글 2개
트랙백 URL: http://reric.com/wp/2007/06/27/507/trackback
음.. 기대했던 unsigned smallint, int 는 제공하지 않는군요..
김홍석 #
네 기존하던데로 check 함수로 제약사항을 만들어야되네요…
reric #