sql server - Convert SQL DateTime format -
how can display datetime
value (2010-12-02 15:20:17.000
) 02/12-2010 15:20
?
for sql server:
select stuff(convert(varchar, getdate(), 105), 3, 1, '/') + ' ' + left(convert(varchar, getdate(), 8), 5)
how can display datetime
value (2010-12-02 15:20:17.000
) 02/12-2010 15:20
?
for sql server:
select stuff(convert(varchar, getdate(), 105), 3, 1, '/') + ' ' + left(convert(varchar, getdate(), 8), 5)
Comments
Post a Comment