Formatting valid xs:dateTime fields with PHP
Recently I had to compose some XML documents that needed to be validated with XSDs. All fine of course, but I had some problem with two date/time fields that according to the XSD were supposed to be xs:dateTime fields. Googling around I found a lot of references to the ISO8601 format, so I decided to format my date using the DATE_ISO8601 constant. That did not work though.
After quite some time puzzling on the issue I decided to just fire off my problem to Twitter.
Awesome as Twitter is for these kinds of things, I had my answer very soon:
Apparently the DATE_ISO8601 is missing the ":" in the timezone offset, and the solution is very simple:
date('c' );
According to the PHP manual, the 'c' string also gives the ISO 8601 formatted string. However, this one is correct and working. Thanks to David Zuelke for giving me this answer, as it ensured my progress in this specific task 
September 8, 2009 - tags: php, xsd, validation, xml, datetime
Comments
David Zülke: A whole article to praise my little help, that really wasn't necessary, Stefan 
With hindsight, my recommendation should actually have been "use RELAX NG", although they use the same data types, so you'd still have had that problem
September 8, 2009
Paul M. Jones: David, it might not have been "necessary", but I think it shows good form on skoop's part. Nicely done, Stefan, nicely done. September 9, 2009
left: David: I like to share such solutions with the community, since it is the community as a whole that also shares their solutions with me Also, Relax NG would not have been an option, since we also depend on an external web service here that also validates using XSD.
Paul: Just my point. Small solutions like these can make the difference between hours of puzzling and remembering that someone solved the problem before you
September 9, 2009
call center technology: This is really great issue I too faced problem regarding this fact and was searched for answer at many places and even googled for the answer but didn’t find exact answer. Even if I come across any answer they are not understandable and lengthy. David zuelke really helped all of us in this matter. He explained it in simple way which can be understandable by even layman.March 28, 2011
Craigslist Toyota cars for sale: Interesting post.this problem is simple and easily to solve.you think much about it.i really like this post.thanks for sharing.August 10, 2011
free online dating: I thought I would leave my first comment. I dont know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often. October 14, 2011
Craigslist Wisconsin: Interesting post.i like to read informative blogs and this blog is also so good and helpful.thanks for taking time to discus this topic..October 28, 2011
orlando truck accident attorneys: The time fields work so good in php. I see the options are so good. The work is so good on this. October 28, 2011
craigslist Portland: i think your thoughts are good and you think very well about this topic.this blog is so good and helpful.thanks for taking time to discus this topic..November 22, 2011
Domain name India: This is my first visit to your site. Today I have got a new site. I am really happy to be here. I am stay tuned here for your next blog...November 22, 2011
AAJ News: o think Twitter is reply perfect answer of this question.This is really interesting, You are a very skilled blogger.thanks for this post.November 27, 2011
professioneller Linkaufbau: After quite some time puzzling on the issue I decided to just fire off my problem to Twitter. December 6, 2011
rwswf: This is really great issue I too faced problem regarding this fact and was searched for answer at many places and even googled for the answer but didn’t find exact answer. Even if I come across any answer they are not understandable and lengthy. David zuelke really helped all of us in this matter. He explained it in simple way which can be understandable by even layman.December 23, 2011
Oakley Sunglass Sale: oakley m frame sunglasses You are to assist Zhou Miaoyi falling off the case. tf42srzoakley sunglasses on sale Hey, how do you come? She have a crush on this younger.
oakley radar path It is also rich girl actually choose to live quarters, is to facilitate contacts with the loved it?
www.cheapestoakleysunglass.com Sun is a look at gourmets moment, whispered: "I'm sorry, wrong person, you are a new student?"
January 3, 2012
discount uggs: Thanks for the great information. Sometimes its difficult to figure this stuff out without any help. Its good to know that help can be found here, thanks.... steelers jerseys for kidsJanuary 3, 2012
cheap ugg boots: Good to see this specific placement from your side. I guess such sharing can easily become helpful for some kind of research work. So keep sharing in future as well cheap ugg bootsJanuary 3, 2012
ugg boots cheap: Very nice blog. Thanks for being considerate and posting this for us. cheap ugg boots for saleJanuary 3, 2012
steelers jersey: people are enjoying and take some mind refreshment in this nite discount ugg bootsJanuary 3, 2012
uggs boots: uggs boots Sir. Xu Biao what to say, but stopped around his political commissar Zhao, Xu Biao can only listen to the words of political commissar, Li Bin, your heart does not feel the pinch of the sweat.What? Woman? Li Bin actually see each other's voice is a woman, surprised, said Li Bin, it is no wonder Shang Jing, painted camouflage face oil, coupled with large cover of Keith Davis combat helmet hair, it could not distinguish between men and women. LKM&*kjKJ everyone tidy uniforms, although the veterans wear very disappointing, but Zheng Ambush, retreat, retreat. Sun platoon command team members leave the side, while his gun back. uggs boots for sale Kai, someone looking for you. Han Zhu is a police officer and discussed the case of Kai.company headquarters company commander, when Meng would Anjiao bad, but it was all uggs boots on sale At this point all suddenly shut up Don Minnesota, think of Captain Shang Xuelang special forces arrived, he had disdain for her is so, the results on the training ground and fell one by Captain Shang's injury, now think of it, the body unconsciously shuddered. uggs boots sale his life's largest veterans loud voice shouted. www.hotbootsshop.comJanuary 10, 2012
ugg outlet online: Read a lot of similar articles, but only found this article to my taste, thank you January 18, 2012
coach outlet online: If you buy Coach items at thecoach outlet online
store, the goods will be sent out within 24 hours after confirming your payment and arrive to your door within 7 work days.No one can deny the shopping at the
coach factory outlet
is satisfactory. For the low prices and good quality.
January 29, 2012
coach outlet: coach outlethandbags You can not just save your cash but also your time inside a convenient way to obtain the exact same bags product and do not be concerned the shippment of one's products.The
coach outlet store online
are utilized for formal event in company area that will display your excellent taste.Not only does a briefcase make is easier to carry things.
January 29, 2012
frases para msn: I accept a table that has 2 fields authentic as Date/Time. At the INSERT INTO time, how can I leave those fields BLANK or admit a NULL in them?January 31, 2012
discount uggs boots: I'd have to check with you here. Which is not something I usually do! February 1, 2012
michael kors watches: enjoyed reading your articles excellent stuff keep up the good workFebruary 2, 2012
IT Support Farmworth: These kind of post are always inspiring and I prefer to read quality content so I happy to find many good point here in the postFebruary 3, 2012
Rental Bunbury: Please tell me what XML & XSDs is and what is the difference in both?February 4, 2012
Upcoming events
06-02-2012: D-Day 17-02-2012: Techademy Trainingday February 23-02-2012: Zend Webinar: Git for Subversion Users