Hi Dan. Is VC using RDBO?
Tim. On Thu, Dec 21, 2006 at 03:45:25PM -0800, Dan Wierenga wrote: > When I retrieve a datetime field from a mysql database, it gets a "T" > stuck in between the date and time fields of the return value (for > "Time", I assume). Is there a way to suppress this and have a space in > the field as I'm expecting? I don't see anything in the RDBO > documentation about it. Looking in the DateTime documentation it seems > that's standard for the DateTime::datetime function. I don't see anyway > of overriding it from the Rose objects though, and I've learned to ask > questions on mailing lists before I start poring through CPAN code. :) > > Example: > > mysql>SELECT user_name, expires from user; > +---------------------------+---------------------+ > | user_name | expires | > +---------------------------+---------------------+ > | [EMAIL PROTECTED] | 2006-12-21 13:59:59 | > +---------------------------+---------------------+ > > using this code snippet: > > > > > my $user = My::User->new(user_name => '[EMAIL PROTECTED]'); > ##My::User has 'use base qw(Rose::DB::Object);' > $user->load; > print $user->expires; > > I get: > 2006-12-21T13:59:59 > > > Obviously, I could just s/T/ /g on any field that's a datetime in my > database, but I'd like a cleaner way that will make all datetime fields > return as they are in the mysql client. > > > Any ideas? I've just started with RDBO so I apologize if I've missed > something obvious or something covered in the docs. > > Thanks, > Dan > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Rose-db-object mailing list > Rose-db-object@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/rose-db-object ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
