Great! At the moment I use Datetime::Format::MySQL because my 'ALTER SESSION' statements in on_connect_do set the date format to exactly the same which D::F::MySQL uses.
-Alex > -----Original Message----- > From: Nathan Gray [mailto:[EMAIL PROTECTED] > Sent: Monday, November 06, 2006 3:24 PM > To: [email protected] > Subject: [Dbix-class] ANNOUNCE: Datetime::Format::Oracle > > Oracle's date datatype is supported via parse_date, format_date, > parse_datetime, format_datetime. > > I plan to add 'timestamp' and 'timestamp with time zone' methods after > I install 9i client libraries on my computer. > > I request that a datetime_parser_type method be added to > DBIx::Class::Storage::DBI::Oracle: > > sub datetime_parser_type { return "DateTime::Format::Oracle"; } > > I am concerned by the treatment of 'datetime' and 'timestamp' in > DBIx::Class::InflateColumn::DateTime. > > In Oracle, the 'date' datatype may contain time information, so is > really a datetime datatype. The 'timestamp' datatype in Oracle adds > fractional seconds, and the 'timestamp with time zone' datatype adds > time zone information. > > My concern is that DBIx::Class::InflateColumn::DateTime uses the > 'parse_datetime' and 'format_datetime' methods for 'timestamp' > datatypes. In Oracle, the format of each of the three time datatypes > are controlled by separate formatting settings, so the formats may > be different from each other. > > I am also concerned that 'timestamp with time zone' datatypes are > ignored by DBIx::Class::InflateColumn::DateTime. > > I would like to see 'timestamp with time zone' run the > parse_timestamp_with_time_zone and format_timestamp_with_time_zone > methods, if they are available, and fall back to timestamp methods > otherwise. > > So 'timestamp with time zone' would attempt, in this order: > > parse_timestamp_with_time_zone > parse_timestamp > parse_datetime > > and > > format_timestamp_with_time_zone > format_timestamp > format_datetime > > A plain 'timestamp' datatype would attempt, in this order: > > parse_timestamp > parse_datetime > > and > > format_timestamp > format_datetime > > Oracle also has a 'timestamp with local time zone' datatype, which > really is just a timestamp (and will not return nor accept time zone > information). It is special in that it uses the time zone of the > session to calculate the date and time to return. For this datatype, > it seems the order of methods to try would be: > > parse_timestamp_with_local_time_zone > parse_timestamp > parse_datetime > > If it is agreed that there should be a > 'parse_timestamp_with_time_zone' in that list, I can support that. > > In any case, Enjoy! > > -kolibrie > > > _______________________________________________ > 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/dbix- > [EMAIL PROTECTED]/ *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* 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]/
