Thank you, Martina.
I also just saw it in the help for Convert function. I don't know why I used Japan. Maybe I wanted to date to be shown as yyyy/mm/dd Or maybe I just made a mistake. Funny thing that no customer has noticed it. I am just doing some refactoring and noticed it.
>Hi,
>
> 111 is Japan, 110 is US (different delimiters)
>
>MartinaJ
>
>>Hi,
>>
>>I know I should know it since I have this code in my application. But I would like to confirm that my understanding is still (after so many years) is correct.
>>
>>I have this code:
>>
>>Convert( varchar(11), date_time, 103)
>>
>>and
>>
>>Convert( varchar(11), date_time, 111)
>>
>>
>>Does the above mean to convert a DATETIME column to a string of British format (103) and US format (111)?
>>
>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham