Hi,
I think the issue is you need to configure the oracle date format to be
something that PHPs strtotime can parse. I think the documentation mentions
something about this somewhere.
Thanks, Jon
On Fri, Dec 3, 2010 at 9:55 AM, Zuchuat Bertrand
<bertrand.zuch...@rero.ch>wrote:
> Hi,
>
> I would like to use the definition date with Oracle but i have a convention
> problem.
>
> - My Entity:
> class vevolution
> {
> /**
> * @orm:Id
> * @orm:Column(type="date")
> */
> private $day;
>
> public function getDay()
> {
> return $this->day;
> }
> }
>
> - My query in my function:
> $em = $this->get('doctrine.orm.entity_manager');
> $q = $em->createQuery('SELECT e FROM StatOpacBundle:vevolution e');
> $evolutions = $q->getResult();
>
>
> - Exception:
> Could not convert database value "26-JAN-10" to Doctrine Type date
>
>
> I tested with this syntax but i have an error:
>
> $q = $em->createQuery('SELECT to_date(e.day, "YYYY-MM-DD") dymd,
> e.day_yyyymm, e.day_sum_count_val FROM StatOpacBundle:vevolution e');
>
> [Syntax Error] line 0, col 7: Error: Expected known function, got 'to_date'
>
>
>
> Thanks for your help
>
> Bertrand
>
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" group.
> To post to this group, send email to symfony-users@googlegroups.com
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com>
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en
>
--
Jonathan H. Wage
http://www.twitter.com/jwage
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
