SQL Date FORMAT

علی ذوالفقار
1400/04/09 11:42:02 (55)
Format date-time in sql-server :
format(update_datetime , 'yyyy/MM/dd') => convert datetime field to 1234/56/78 format
convert(nvarchar(10), getdate() , 111) -> 1234/56/78
select convert(nvarchar(10), getdate() , 8) -> time 12:33:45
Back