sql server 2008 r2 query date time Indirect needed
-
Thursday, January 17, 2013 9:52 AM
I want date format thai. example 17/1/2556 but it show 1/17/2556. by locale=thai,location=thailand,date time 17/1/2556, language on sql server is THAI_CL_AS, dafault language database=thai.
How to solve the problem.
thank you very much.
THAILAND
sorry,if sentence format incorrect or You do not understand.
All Replies
-
Thursday, January 17, 2013 11:29 AM
Hello ,
Please take a look on the below link for the solution
Best Regards Sorna
-
Friday, January 18, 2013 2:57 AM
data type date without format option for set on sql server 2008 r2 standard edition
Thank you.
-
Thursday, February 14, 2013 1:49 AM
Hi TP,
If you really want to be pedantic, you can code the format yourself, such as
select
DATENAME(dd,getdate())+'/'+
CONVERT(VARCHAR(2),DATEPART(mm,getdate()))+'/'+
DATENAME(yy,getdate())http://RichardLees.blogspot.com
Richard
- Proposed As Answer by RichardLees Thursday, February 14, 2013 1:49 AM
.png)
