Ah No. This is executed in .NET class.
The original code was as Stefano mention which is something like:
String objTemp = value.ToString("yyyy/dd/MM hh:mm:ss.fff");
Unfortunately, I encountered an error when the Windows OS used is localized
(i.e. Windows XP Simplified Chinese Edition) so I had to explicitly convert the
data.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of bill lam
Sent: Friday, September 11, 2009 9:48 AM
To: [email protected]
Subject: Re: [Jprogramming] Extending dates.ijs
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
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
