SQL Server Datetime To String Example

프로그램/database

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