Date Time Format problem

Question

User2067508032 posted

Hi Experts/Members

I have a prob here which is to sub-string the date.
My current data is like this '10 May 13/10:33' in normal .

I using with this query.

select convert(varchar(20),day(date),100) + ' '+
REPLACE(RIGHT(CONVERT(VARCHAR(9), date, 6), 6), ' ', ' ') +'/'+
REPLACE(RIGHT(CONVERT(VARCHAR(5), date, 8), 8), ' ', '') as [Time]
from record where id='16145'

I tried this but the output from Indonesia seems like incorrect '10 maj 13/10:33'

Kindly provide some advice.. Appreciate for the help

Answer 1

User-1598965247 posted

'10 maj 13/10:33'

maj is the May month of some other language.

check this query, you ll get idea

 Select * from sys.syslanguages where shortmonths like '%maj%'

Answer 2

User2067508032 posted

Thanks you heyitsme. I have to check also culture info.

But I dont know why?? ;-(

Answer 3

User-1598965247 posted

what exactly is your requirement. can you make it bit clear?

Answer 4

User-1716253493 posted

I sugest you to format it in aspx page instead sql

DataFormatString="{0:dd MMM yy/hh:mm}"

or

Label.Text=yourdate.ToString("dd MMM yy/hh:mm")

Answer 5

User2067508032 posted

My problem is when they run my program at Indonesia server month is change.That all :D

Answer 6

User-1598965247 posted

you can execute this query which will change the language to engish

 
 set language english

Answer 7

User2067508032 posted

I aldy done my dear ;-(

Answer 8

User-1716253493 posted
set page uiculture="id-ID"

Answer 9

User2067508032 posted

pls explain me I dont understand

set page uiculture="id-ID" 

Answer 10

User-1716253493 posted

set at top your page

<%@ Page Culture="string" UICulture="string" ...

or globalization web.config

<globalization culture="string" uiCulture="string"/>

http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo(v=vs.71).aspx

http://msdn.microsoft.com/en-us/library/bz9tc508(v=vs.100).aspx

Answer 11

User2067508032 posted

Finally, can solve.

Microsoft SQL server managment studio then to login default language must be English . Thank for help me .