thanks foxxo for the reply, actually both PC are using the same front-end, with regards to application i've check with the programmer they say they dont do any setting with regards to the date during the connection, so they basically connecting as to what is the default setting.

as per what i see in the profiler, once the user start the connection to sql server they have same setting for both PC.

will there be any bearing with regards to how the client setup the regional settings or language (keyboard input) locally?

the pc that showing the data was set as 'DD/MM/YYYY', but when i see the profiler the date come out as 'May 17, 2013' instead of '17/05/2013' so im a bit confuse how the SQL set the date in the query.