I'm trying to display a datetime from my MySQL database as an iso 8601 formated string with PHP but it's coming out wrong. 17 Oct 2008 is coming out as: 1969-12-31T18:33:28-06:00 which is clearly not correct (the year should be 2008 not 1969) This is the code I'm using: <?= date("c", $post[3]) ?> $post[3] is the datetime (CURRENT_TI...
Hello, I am currently using PHP/MySQL and the jQuery timeago plugin. Basically, I need to pull my timestamp from the database and convert it to ISO 8601 format. Like this 2008-07-17T09:24:17Z Currently, my timestamps are in the database in this format: 0000-00-00 00:00:00 I have tried using timeago with my currently formatted time...
I am trying to convert a querystring value into Javascript date object and then converting it into ISO Date format. I have three button - one extracts the querystring and displays the value - works properly Second, uses first function to extract querystring (works) and then converts to Date - fails - get NaN Third, passes a hardcoded st...
How are you currently parsing ISO8601 dates e.g. 2010-02-23T23:04:48Z in JavaScript? Some browsers return NaN (including Chrome) when using the code below, FF3.6+ works though. <html> <body> <script type="text/javascript"> var d = Date.parse("2010-02-23T23:04:48Z"); document.write(d); </script> </body> </html> You can try this...
Dear all, I have searched for a while and can't seem to find anything that's related to this. I need to validate an ISO 8601 time interval. There is loads of stuff about ISO 8601 date times but i specifically need interval. I am using a regex and this is what I have so far; Regex regEx = new Regex(@"^P((\d+)Y)((\d+)M)((\d+)D)(T)((\d...