in reply to Re^2: Using DBI::Sybase having problem with Date format
in thread Using DBI::Sybase having problem with Date format
I don't know which columns are dates (so, I'll assume those prefixed with dt are). For your test script, you would have to change from
tomy $sth = $dbh->prepare_cached( "SELECT * FROM ReleaseDates" );
for the cgi:my $sth = $dbh->prepare_cached( "SELECT convert( char(8), dtXXX, 101 ) FROM ReleaseDates" );
tomy $sth =$connection->prepare( "SELECT Release, dtTargetFeatureFreeze, dtTargetCCRB, dtTargetReleaseFromDev, dtTargetRTM, TwikiURL, ReleaseNum, Display FROM ReleaseDates WHERE (Display = 1)" );
my $sth =$connection->prepare( "SELECT Release, convert( char(8), dtTargetFeatureFreeze, 1), convert( char(8), dtTargetCCRB, 1), convert( char(8), dtTargetReleaseFromDev, 1), convert( char(8), dtTargetRTM, 1), TwikiURL, ReleaseNum, Display FROM ReleaseDates WHERE (Display = 1)" );
update: BTW, setting dateformat only affects inputting dates.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^4: Using DBI::Sybase having problem with Date format
by Anonymous Monk on May 11, 2007 at 08:40 UTC |