I believe the c format will have to be stored as a string and not as a
DateTime as per the mysql limitation. That is why i asked in view that
phpcr is not tied to mysql. So I wonder if you guys went for some standard
format. We are splitting this into two properties but I wonder what is best.


On Sat, Feb 23, 2013 at 4:07 PM, Willem-Jan Zijderveld <
notifications@github.com> wrote:

> In src/Jackalope/Transport/DoctrineDBAL/Client.php:
>
> > @@ -815,7 +815,7 @@ private function propsToXML($properties, $inlineBinaries = false)
> >                      if (!$date instanceof \DateTime) {
> >                          $date = new \DateTime("now");
> >                      }
> > -                    $values = $date->format('r');
> > +                    $values = $date->format('Y-m-d H:i:s');
> >                      break;
>
> Not with the format I chose here. I didn't think about that. I'm not sure
> what's a best practice for this. Normally in MySQL datetime format, you
> can't save timezone right? But when required, I guess we could go with the
> 'c' format (2004-02-12T15:19:21+00:00). Sorting and filtering should still
> work. Op 23 feb. 2013 om 21:06 heeft Luis Cordova <
> notifications@github.com> het volgende geschreven:
> … <#13d08e1e157cc239_>
>  In src/Jackalope/Transport/DoctrineDBAL/Client.php: > @@ -815,7 +815,7 @@
> private function propsToXML($properties, $inlineBinaries = false) > if
> (!$date instanceof \DateTime) { > $date = new \DateTime("now"); > } > -
> $values = $date->format('r'); > + $values = $date->format('Y-m-d H:i:s'); >
> break; sorry for this dumb question but are we storing also timezone? how
> is that handled? — Reply to this email directly or view it on GitHub.
>
> —
> Reply to this email directly or view it on GitHub<https://github.com/jackalope/jackalope-doctrine-dbal/pull/90/files#r3127392>.
>
>