getdate()에 1초 더하기
SELECT getdate(),(dateadd(s,1,getdate()))
| OpenTSDB: Scalable time-series database (0) | 2013.11.21 |
|---|---|
| [DB] RocksDB: Persistent key-value store for fast storage http://ow.ly/2BzPfY (0) | 2013.11.20 |
| [NoSql] NoSql 활용 - 특징 (0) | 2013.11.05 |
| [MSSQL] 저장프로시저 내용 보기 - SP, Stored Procedure (0) | 2013.09.23 |
| Robomongo - cross-platform MongoDB (0) | 2013.09.16 |
--Getdate()
Select Getdate()
--YYYY/MM/DD
Select Convert(varchar(10),Getdate(),111)
--YYYYMMDD
Select Convert(varchar(10),Getdate(),112)
--HH:MM:SS
Select Convert(varchar(8),Getdate(),108)
--HH:MM:SS:mmm
Select Convert(varchar(12),Getdate(),114)
--HHMMSS
Select Replace(Convert(varchar(8),Getdate(),108),':','')
--HHMMSSmmm
Select Replace(Convert(varchar(12),Getdate(),114),':','')
--YYYY/MM/DD HH:MM:SS
Select Replace(Convert(varchar(30),Getdate(),120),'-','/')
--YYYY/MM/DD HH:MM:SS
Select Replace(Convert(varchar(30),Getdate(),121),'-','/')
--YYYY/MM/DD HH:MM:SS
Select Convert(varchar(10),Getdate(),111) + Space(1) + Convert(varchar(8),Getdate(),108)
--YYYYMMDDHHMMSS
Select Convert(varchar(10),Getdate(),112) + Replace(Convert(varchar(8),Getdate(),108),':','')
| [mssql] 숫자 앞에 0 으로 채우기, Replicate (0) | 2013.09.12 |
|---|---|
| [MSSQL] 임시 Table 존재유무 확인 (0) | 2013.07.12 |
| [MSSQL] ASP, MSSQL 에서 날짜 비교 (0) | 2013.07.09 |
| [MYSQL] Pinba — A MySQL storage engine and monitoring server (0) | 2013.07.08 |
| Oracle SQL Developer 3.2.2 (0) | 2013.05.23 |
날짜 - reg_day
현재 날짜 : getdate() -> select getdate()
select convert(VARCHAR, reg_day, 120)
-> 날짜를 문자형(varchar)으로 변환
CAST, dateadd(), datediiff() 등이 있다.
| [MSSQL] 임시 Table 존재유무 확인 (0) | 2013.07.12 |
|---|---|
| [MSSQL] mssql, getdate() 날짜 포멧 (0) | 2013.07.12 |
| [MYSQL] Pinba — A MySQL storage engine and monitoring server (0) | 2013.07.08 |
| Oracle SQL Developer 3.2.2 (0) | 2013.05.23 |
| [NoSQL] Riak - Full Text Search (0) | 2013.03.18 |
