Display of date format in Japanese machine.

• Unnikrishnan.C

  Old Hand

  Points: 320

  More actions

  May 17, 2006 at 6:46 am

  #172700

  Hi,

  We installed MS SQL in a Japanese machine and it has been noticed that our application is not able save the date in a format with AM and PM as suffix. For e.g. it won’t allow us to save a datetime as '2006/05/17 5:28:07 AM'. If we change the value using Enterprise manager to one with AM or PM, it is reverting back to '2006/05/17 5:28:07'. How can I change/save the date value with AM & PM suffix in a Jap machine? And what could be the reason for this behavior?

  Thanks in advance

  Unnikrishnan

• May 22, 2006 at 8:00 am

  This was removed by the editor as SPAM

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  June 28, 2006 at 1:59 am

  #646296

  See Regional Settings in Control Panel.

  ---

  N 56°04'39.16"
  E 12°55'05.25"