datedatetimedate-formattingculture

Difference between dd-mm-yyyy and dd-mmm-yyyy

Is it ok to use dd-mm-yyyy or dd-mmm-yyyy for UK. I used dd-mmm-yyyy format in my web application for UK.

Select  CONVERT(varchar(11),ArrivalDate,106)

But the PM asked me,

Are you sure that this is the correct date format for UK ?

I searched on Web but find dd-mm-yyyy and nothing about dd-mmm-yyyy for UK. Can you please tell me whether they both are two different formats for different countries or its just display style and could be used for a country like UK ?

Solution

  • It is only Display style.