Hi Stefano, It was originally coded that way. It actually worked quite well during development and QA but when we deployed it to our factories in China ... we immediately stumbled into the problem where instead of "/", were getting the Unicode/simplified Chinese equivalent. The problem only occurs if the client machine is localized or what we call "Chinese" version. We didn't encounter the problem if the client machine is a normal English Windows XP with the Asian Language pack. It was throwing our SQL DML commands to haywire.
r/Alex P.S. I missed your signature which said, "Everything I learned, I learned from Anime!". ;) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stefano Lanzavecchia Sent: Thursday, September 10, 2009 3:39 PM To: 'Programming forum' Subject: Re: [Jprogramming] Extending dates.ijs > To import a DataTime object from a DataTable to J, I actually convert > this first into a string in this format: MM/DD/YYYY HH:MM:SS.MS <lang > C#> > string objTemp = value.Month.ToString() + "/" + > value.Day.ToString() + "/" + value.Year.ToString(); > objTemp += " " + value.Hour.ToString() + ":" + > value.Minute.ToString() + ":" + value.Second.ToString(); > objTemp += "." + value.Millisecond.ToString(); </lang> Assuming "value" is a System.DateTime object, wouldn't it be easier to format it with: <lang C#> String objTemp = value.ToString("yyyy/dd/MM hh:mm:ss.fff"); </lang> -- WildHeart'2k9 - mailto:[email protected] My digipics and blogs: http://wildy2k5.spaces.msn.com/ My Music: http://www.myspace.com/wildy2k7 [[The main reception foyer was almost empty but Ford nevertheless weaved his way through it. --- The Best Quotes from The Hitchhiker's guide to the Galaxy]] ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
