May 17, 2006 at 6:50 am
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 17, 2006 at 7:22 am
The reason I don't know but print out the eight pages from the link below it will show you how to create location neutral DateTime for your database. Hope this helps.
http://www.karaszi.com/SQLServer/info_datetime.asp
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
May 17, 2006 at 10:12 am
Japanese time does not have AM and PM; it's a 24-hour clock.
Instead of 5:27pm, use 17:27.
12:00 am = 0:00
6:00 am = 6:00
12:00 pm = 12:00
6:00 pm = 18:00
-Eddie
Eddie Wuerch
MCM: SQL
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply