May 17, 2006 at 7:00 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:23 am
If the column is defined as datetime, then there is no such thing. What you are seeing is a translation of the actual stored value into a displayable format. To see it in the fprmat you would like, take a look at CONVERT in BOL.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp
see here for date / time functions:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_2c1f.asp
see here for a discussion of datetime:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_9xut.asp
May 17, 2006 at 7:39 am
Also, don't cross-post.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply