'MS-SQL'에 해당되는 글 15건

  1. 2010.04.02 MS SQL DateTime 비교
2010.04.02 17:55

MS SQL DateTime 비교

select * from table_name where condition_1
and
(cast(sd_date as smalldatetime) >=  cast('2006-05-02 00:00:01' as smalldatetime)
and
cast(sd_date as smalldatetime) <= cast('2006-05-02 23:59:59' as smalldatetime))

[출처] MS-SQL DateTime 크기 비교하기

Trackback 0 Comment 0