Sql to change multiple dateformat into one date format

Question

how to change multiple dateformat to one dateformat in sql?

I am currently using my Java code. however, I would like to change using the sql function so that I do not need to use a different connection between my java program and the database.

My current code is below:

-

any pointer will be appreciated

Answer 1

Made a hardcode as below, but I think this is bad code :(

DECLARE @finalDate nvarchar(20) SET @finalDate = CONVERT(nvarchar(15), '2011/01'+'/01' ,100); print @finalDate;