DateTime format for German language RRS feed

  • Question

  • Hi,

    i am using yyyy-MM-dd format as global format sql server datetime. But in german OS and german language sql server not working.


    please provide the global format Datetime string to Database.

    Tuesday, December 14, 2010 8:25 PM


  • You should not store dates as formatted strings, but instead store them as Date or DateTime types in database. In this case dates will be stored inside of database in language-independent format. How you represent them to the user on UI is different story and there you can apply any formatting patterns you want.


    Val Mazur (MVP)


    • Marked as answer by Jackie-Sun Tuesday, December 21, 2010 9:05 AM
    Wednesday, December 15, 2010 11:41 AM