How can i change datetime format in sql?

Question

How can i change dateformat?Forexample:

2009-06-10 10:16:41.123

->2009-June

2009-05-10 10:16:41.123

->2009-May

Answer 1

Try this:

select cast(datepart(year, mydatecolumn)  as char(4)) + '-' 
   + datename(month, mydatecolumn)
from mytable

Answer 2

You should not change the date-format in your database. You should just make sure that , when displaying the date, you correctly format the date, so that you display them in the format that you want.

How to do that, is related to the language you use in your program. You can also output the date directly in the format you want using the method of ck.

Answer 3

heres a link to a table with common formats

Answer 4

To interpret input use SET DATEFORMAT

To cast to character, see the CONVERT styles.

To format output, use whatever your client environment uses to format output, SQL itself has no output but TDS and display is left to the client.

Answer 5

Its a pain to do custom formats without writing your own function.

best i have is SELECT NewFormat = YEAR(GETDATE()) + '-' + DATENAME(month, GETDATE())