How can I format datetime values in SQL Server?

Question

hi

How can I format the following datetime values:

2010-01-21 00:00:00.000 - as - 21/01/2010

and

1900-01-01 09:09:18.000 - as - 09:09:18

Answer 1

See Cast and convert

e.g.

convert(varchar(50), date_variable, 103 ) -- for the first case

Answer 2

CASE WHEN Year([DateColumn]) = 1900 THEN CONVERT(varchar(8), [DateColumn], 114)
     ElSE CONVERT(varchar(10), [DateColumn], 103) END