프로그램/database

SQL Server Datetime To String Example

mulderu 2014. 1. 17. 10:18


sqlserver datetime to string example :)




select GETDATE() basedate,convert(varchar, GETDATE(), 1) basestring

    ,left(convert(varchar, GETDATE(), 1),2) month,right(left(convert(varchar, GETDATE(), 1),5),2) day

    ,right(convert(varchar, GETDATE(), 1),2) year


select GETDATE() basedate,convert(varchar, GETDATE(), 8) basestring

    ,left(convert(varchar, GETDATE(), 8),2) hour,right(left(convert(varchar, GETDATE(), 8),5),2) minutes

    ,right(convert(varchar, GETDATE(), 8),2) sec


'프로그램/database'의 다른글

  • 현재글SQL Server Datetime To String Example

관련글

티스토리툴바