In SSMS, is it possible to display date fields in the result query in the language format of the user's database without utilizing Convert or Format in SQL?

asked 2022-12-27 11:00:00 +0000

huitzilopochtli
41 ●4 ●3

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2022-11-07 02:00:00 +0000

woof
21 ●1 ●1

No, it is not possible to display date fields in the result query in the language format of the user's database without utilizing Convert or Format in SQL. The default date format of SQL Server is based on the language of the system, and it does not automatically adjust to the language of the user's database. Therefore, Convert or Format functions are necessary to achieve this requirement.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools

Stats

Asked: 2022-12-27 11:00:00 +0000

Seen: 13 times

Last updated: Nov 07 '22

In SSMS, is it possible to display date fields in the result query in the language format of the user's database without utilizing Convert or Format in SQL? edit

1 Answer