On Thu, 10 Sep 2009, Alex Rufon wrote: > 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>
Is this an external \.net function to be executed by m$sql? It may be more efficient to use in-built function such as datepart to do the conversion. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
