What is the default date datatype format for Oracle? I set it with on_connect_do (why I added it to dbic...) ALTER SESSION statements like I did before using cdbi and dbic to make sure in which format it returns dates.
Luckily my chosen format is the same one MySQL uses, which is the default parse format for DBIC, so date de-/inflating works for me. -Alex > -----Original Message----- > From: Nathan Gray [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 17, 2007 11:26 PM > To: [email protected] > Subject: Re: [Dbix-class] DBIx::Class::InflateColumn::DateTime for DB2 > > On Wed, Jan 17, 2007 at 09:11:51AM +0000, Jess Robinson wrote: > > Well, if someone could check that all DateTime::Format::X modules > contain > > parse_ functions named after the appropriate datatypes, I would prefer > to > > remove the "timestamp isa datetime" line in InflateColumn::DateTime. > > > > IIRC, some DBs have both, and the formatting isn't quite the same? > MySQL > > 3.x anyone? > > Oracle also has 'date' and 'timestamp' datatypes. A 'date' really is > a datetime, and 'timestamp' adds the ability for timezone information, > which is missing from 'date' for some reason. > > I would welcome the removal of "timestamp isa datetime" in > InflateColumn::DateTime. > > I can update DateTime::Format::Oracle to have whatever parse_ > functions it should have. I checked a few others to see what they > had, but didn't find any kind of formal spec on how to write them. > > -kolibrie *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* 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. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* _______________________________________________ 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/ Searchable Archive: http://www.mail-archive.com/[email protected]/
