| Author |
Message
|
| edasnarik |
 Posted: Thu Feb 18, 2010 6:05 am Post subject: Problem with datetime parser |
 |
|
Acolyte
Joined: 10 Mar 2009
Posts: 61
|
Unable to parse value '2003-08-04T00:45:23166' using format string 'yyyy-MM-dd'T'HH:mm:ssZZZ'. Strict Datetime Checking = '1'.
Unable to parse value '2003-08-04T00:45:23166' using format string 'HH:mm:ssZZZ'. Strict Datetime Checking = '1'.
Unable to parse value '2003-08-04T00:45:23166' using format string 'yyyy-MM-dd'T'HH:mm:ssZZZ'. Strict Datetime Checking = '0'.
Unable to parse value '00:45:23166' using format string 'HH:mm:ssZZZ'. Strict Datetime Checking = '0'. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Thu Feb 18, 2010 6:18 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| are you sure that ZZZ is miliseconds? |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Feb 18, 2010 6:27 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
|
| Back to top |
|
|
| edasnarik |
| Posted: Thu Feb 18, 2010 6:37 am Post subject: |
|
|
Acolyte
Joined: 10 Mar 2009
Posts: 61
|
| mine is a XML Message Set generated from Acord 1.3 Schema |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Feb 18, 2010 8:37 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Look in the infocentre section titled "DateTime as String Data" it will tell you everything you need to correct this problem
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| edasnarik |
| Posted: Thu Feb 18, 2010 9:55 pm Post subject: |
|
|
Acolyte
Joined: 10 Mar 2009
Posts: 61
|
| mqjeff wrote: |
| are you sure that ZZZ is miliseconds? |
I am not sure , and is it Zonal Information ? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Feb 18, 2010 10:06 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Quote: |
| '2003-08-04T00:45:23166' |
That time format looks a little bit bizarre to me...
Shouldn't look more like '2003-08-04T00:45:23.166' Note the additional '.' to mark the second / millisecond separation....
And the format should look something like: 'yyyy-MM-dd'T'HH:mm:ssSSS' in the first case and like 'yyyy-MM-dd'T'HH:mm:ss.SSS' if the addional demarcation between seconds and milliseconds is taken.
 It's all in the relevant documentation about Date Time formats 
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
