공동주택 관리정보
게시판
      
상위분류 : 잡필방 중위분류 : 서류가방 하위분류 : 전산과 컴퓨터
작성자 : 문시형 작성일 : 2017-10-18 조회수 : 4,460
제 목 : SQL 날짜 비교 및 년간, 월간, 일간 등 검색

MS SQL 날자 비교.

 DB/쿼리 2009.10.21 11:23

 

REGDATE 형식이 Date 형식일 경우 

* 2009-10-07 데이터가 있을 경우
1. 결과 나옴 
 WHERE CONVERT(CHAR(10),T1.REGDATE,23)
        BETWEEN CONVERT(CHAR(10),'2009-10-06',23) AND CONVERT(CHAR(10),'2009-10-07',23)


2. 결과 안나옴
 WHERE  T1.REGDATE
        BETWEEN CONVERT(CHAR(10),'2009-10-06',23) AND CONVERT(CHAR(10),'2009-10-07',23)


참조 표
 

 

0 Feb 22 2006 4:26PM CONVERT(CHAR(19), DATETIME, 0)
1 02/22/06 CONVERT(CHAR(8), DATETIME, 1)
2 06.02.22 CONVERT(CHAR(8), DATETIME, 2)
3 22/02/06 CONVERT(CHAR(8), DATETIME, 3)
4 22.02.06 CONVERT(CHAR(8), DATETIME, 4)
5 22-02-06 CONVERT(CHAR(8), DATETIME, 5)
6 22 Feb 06 CONVERT(CHAR(9), DATETIME, 6)
7 Feb 22, 06 CONVERT(CHAR(10), DATETIME, 7)
8 16:26:08 CONVERT(CHAR(8), DATETIME, 8)
9 Feb 22 2006 4:26:08:020PM CONVERT(CHAR(26), DATETIME, 9)
10 02-22-06 CONVERT(CHAR(8), DATETIME, 10)
11 06/02/22 CONVERT(CHAR(8), DATETIME, 11)
12 060222 CONVERT(CHAR(6), DATETIME, 12)
13 22 Feb 2006 16:26:08:020 CONVERT(CHAR(24), DATETIME, 13)
14 16:26:08:037 CONVERT(CHAR(12), DATETIME, 14)
20 2006-02-22 16:26:08 CONVERT(CHAR(19), DATETIME, 20)
21 2006-02-22 16:26:08.037 CONVERT(CHAR(23), DATETIME, 21)
22 02/22/06 4:26:08 PM CONVERT(CHAR(20), DATETIME, 22)
23 2006-02-22 CONVERT(CHAR(10), DATETIME, 23)
24 16:26:08 CONVERT(CHAR(8), DATETIME, 24)
25 2006-02-22 16:26:08.037 CONVERT(CHAR(23), DATETIME, 25)
100 Feb 22 2006 4:26PM CONVERT(CHAR(19), DATETIME, 100)
101 02/22/2006 CONVERT(CHAR(10), DATETIME, 101)
102 2006.02.22 CONVERT(CHAR(10), DATETIME, 102)
103 22/02/2006 CONVERT(CHAR(10), DATETIME, 103)
104 22.02.2006 CONVERT(CHAR(10), DATETIME, 104)
105 22-02-2006 CONVERT(CHAR(10), DATETIME, 105)
106 22 Feb 2006 CONVERT(CHAR(11), DATETIME, 106)
107 Feb 22, 2006 CONVERT(CHAR(12), DATETIME, 107)
108 16:26:08 CONVERT(CHAR(8), DATETIME, 108)
109 Feb 22 2006 4:26:08:067PM CONVERT(CHAR(26), DATETIME, 109)
110 02-22-2006 CONVERT(CHAR(10), DATETIME, 110)
111 2006/02/22 CONVERT(CHAR(10), DATETIME, 111)
112 20060222 CONVERT(CHAR(8), DATETIME, 112)
113 22 Feb 2006 16:26:08:067 CONVERT(CHAR(24), DATETIME, 113)
114 16:26:08:067 CONVERT(CHAR(12), DATETIME, 114)
120 2006-02-22 16:26:08 CONVERT(CHAR(19), DATETIME, 120)
121 2006-02-22 16:26:08.080 CONVERT(CHAR(23), DATETIME, 121)
126 2006-02-22T16:26:08.080 CONVERT(CHAR(23), DATETIME, 126)
127 2006-02-22T16:26:08.080 CONVERT(CHAR(23), DATETIME, 127)
130 24 ???? 1427 4:26:08:080PM CONVERT(CHAR(32), DATETIME, 130)
131 24/01/1427 4:26:08:080PM CONVERT(CHAR(25), DATETIME, 131)

| | 목록으로