/********************************************************************************************
-- Title : [SQL2k8] 날짜/시간 데이터 형식
-- Reference : dbrang.tistory.com
-- Key word : date time datetime smalldatetime datetime2 datetimeoffset
********************************************************************************************/
drop table ttt;
create table ttt
( id int identity
, v_datetime datetime
, v_datetime2 datetime2
, v_smalldatetime smalldatetime
, v_date date
, v_time time
, v_datetimeoffset datetimeoffset
);
insert into ttt
select cast(getdate() as datetime) 'YYYYMMDDT hh:mm:ss.mmm'
, cast(getdate() as datetime2) 'YYYYMMDDT hh:mm:ss.mmmmmm'
, cast(getdate() as smalldatetime) 'YYYYMMDDT hh:mm:ss'
, cast(getdate() as date) 'YYYY-MM-DD'
, cast(getdate() as time) 'hh:mm:ss.mmmmmm'
, cast(getdate() AS datetimeoffset) AS 'YYYYMMDDT hh:mm:ss.mmmmmm +nn:nn';
select * from ttt;