Avatar of tech_question

asked on 

best practices for Sql Server Internationalization to retrieve date ?

what is the best practicse to handle date in sql server for internationalization purpose ? Right now we store
it as date/time field. When we extract it , we use the convert function - CONVERT(varchar(20),test_date, 101 )
to convert it back to the US format. How can we internationlize this with best practices ? Say eg in UK
where it is dd/mm/yyyy.  

Should we write a common function or is there any way to override the existing convert function of sql server  so that we need not make changes to all the stored procedures (is this recommended)?

Oracle DatabaseMicrosoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon