Skip to Content.
Sympa Menu

perfsonar-dev - Re: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?

Subject: perfsonar development work

List archive

Re: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?


Chronological Thread 
  • From: "Jeff W. Boote" <>
  • To: Roman Lapacz <>
  • Cc: maxim <>, 'Loukik Kudarimoti' <>, "'Asif, Mohammad'" <>, 'Maciej Glowiak' <>, , "'Li, Yee-Ting'" <>, 'Nicolas Simar' <>
  • Subject: Re: [pS-dev] Problem with SQL-MA!! Support for ISO timestamp format ?
  • Date: Wed, 17 Jan 2007 09:05:17 -0700

Roman Lapacz wrote:
maxim wrote:
Hi Loukik,
I was testing my SQL MA with L2 status store data requests and I;ve found
that it does not support
this kind of time format <ifevt:datum timeType="ISO"
timeValue="2007-01-16T22:25:00.0-6:00"> ???
Why is that ( taking in account that E2E MP supports this format ) ???

Yes, SQL MA (and RRD MA as well) supports only unix time in the messages. ISO type is supported on the database level (see db schema for L2 path status).

To be clear, I think we realize this is something that eventually needs to be supported. (Otherwise interoperability will not be there.)

But, as Roman said. It is not done yet.

jeff

P.S. I believe the easiest way to support this long-term is to have the nmwg Java objects enhanced to support reading multiple time formats. Then access methods for specific formats can be added to allow applications to read the time in the format that best suits them -- in this case a unix timestamp. But, the client should be able to specify the ISO format in the request. Also, the Java object would need a setting to specify which format to use in the toxml() method.



Archive powered by MHonArc 2.6.16.

Top of Page