목록format (2)

DJ메탈짱™의 Free Style

DataTime.ToString 메소드 (날짜포맷)

DataTime.ToString 메소드 (날짜포맷) /** Output. * * d :08/17/2000 * D :Thursday, August 17, 2000 * f :Thursday, August 17, 2000 16:32 * F :Thursday, August 17, 2000 16:32:32 * g :08/17/2000 16:32 * G :08/17/2000 16:32:32 * m :August 17 * r :Thu, 17 Aug 2000 23:32:32 GMT * s :2000-08-17T16:32:32 * t :16:32 * T :16:32:32 * u :2000-08-17 23:32:32Z * U :Thursday, August 17, 2000 23:32:32 * y :August, 2000 ..
일(job)/MS(Microsoft) 2016. 4. 6. 12:52
[MS-SQL] 휴대전화 포맷 "000-0000-0000" #분리 #SPLIT

declare @str varchar(20) set @str = '010-1234-5678' select substring(@str,1,charindex('-',@str)-1) , substring(@str,charindex('-',@str)+1,4) , substring(@str,charindex('-',@str,9)+1, 4)
일(job)/DBMS 2016. 1. 12. 16:12
이전 Prev 1 Next 다음