* Michael Higgins <[EMAIL PROTECTED]> [080121 10:40]:
> On Sun, 20 Jan 2008 13:44:50 +0000 (GMT)
> Jess Robinson <[EMAIL PROTECTED]> wrote:
>
> >
> > http://desert-island.me.uk:8888/perldists/DBIx-Class-0.08009.tar.gz
> >
> > Changes:
> > - Added Storage::DBI subclass for MSSQL over ODBC.
> >
> > Please poke this tarball some, so we can put it on CPAN!
>
> Doing my best to be helpful here.
>
> There was another addition to this (mentioned above) that I assumed
> would be added in this next release, so I guess I should jump in.
>
> This:
>
> sub build_datetime_parser {
> my $self = shift;
> my $type = "DateTime::Format::Strptime";
> eval "use ${type}";
> $self->throw_exception("Couldn't load ${type}: $@") if $@;
> return $type->new( pattern => '%Y-%m-%d %T' );
> }
>
> ... is missing. (Perhaps Marc Mims is the one to contact, as he added
> the module, but hasn't, it would seem, committed this other key piece.)
Hi, Michael.
I'm trying to find time to finish work on the DateTime issue. I know
the build_datetime_parser you quoted above is working for you, but I'm
not sure it's sufficient for all cases. I believe it needs to handled
dates as well, not just timestamps.
I've done a bit of research and it seems the timestamp format you get
from MSSQL through ODBC may be a standard ODBC format, not an MSSQL
format. I see a similar format, differing only in number of digits in
the fractional seconds, for DB2 over ODBC. That leads me to believe
that build_datetime_parser might be best in ::DBI::ODBC with both
::DBI::ODBC::DB2_400_SQL and ::DBI::ODBC::MSSQL derived from it.
-Marc
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
