목록STRING TO DATETIME (1)

DJ메탈짱™의 Free Style

[MS-SQL] 날짜변환, STRING TO DATETIME #CONVERT() #SUBSTRING()

-- SQL Server string to date / datetime conversion - datetime string format sql server-- MSSQL string to datetime conversion - convert char to date - convert varchar to date-- Subtract 100 from style number (format) for yy instead yyyy (or ccyy with century)SELECT convert(datetime, 'Oct 23 2012 11:01AM', 100) -- mon dd yyyy hh:mmAM (or PM)SELECT convert(datetime, 'Oct 23 2012 11:01AM') -- 2012-1..
일(job)/DBMS 2016. 1. 15. 17:31
이전 Prev 1 Next 다음