[Dbix-class] Inflating and deflating Oracle dates

[Hartmaier Alexander]

I created on_connect_do for exactly this purpose.
I use Oracle and needed to set the date format because the one in the oracle init file isn't used with perl DBI.
I assumed that DBD::Oracle sets it to some DBI standard datetime format...
So I set the date format you seem to use too (from you example) and use this one everywhere.

-Alex


> -----Original Message-----
> From: dbix-class-bounces at lists.rawmode.org [mailto:dbix-class-
> bounces at lists.rawmode.org] On Behalf Of Matt S Trout
> Sent: Monday, June 05, 2006 3:48 AM
> To: dbix-class at lists.rawmode.org
> Subject: Re: [Dbix-class] Inflating and deflating Oracle dates
> 
> Dan Horne wrote:
> >> From: dbix-class-bounces at lists.rawmode.org [mailto:dbix-class-
> >> bounces at lists.rawmode.org] On Behalf Of Matt S Trout
> >>
> >> Couldn't you just mirror how on_connect_do handles this?
> >
> > Quite possibly, now that you've pointed it out to me ;-)
> >
> > I guess the problem I'm experiencing is that I don't know the best way
> to
> > solve this problem. For instance, I don't want to explicity set the
> > NLS_DATE_FORMAT, because that might trash the preferred format of
> another
> > Oracle DBIx::Class user.
> >
> > I'm sure that this is all easily resolved, but I just can't quite see
> it...
> 
> Grab the NLS_DATE_FORMAT and convert it to something
> DateTime::Format::Builder and/or DateTime::Format::Strptime can handle
> maybe?
> 
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/

*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH   Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*