Not sure if this is the write place to ask but here we go.
I need to find a way to get date fields in a database to be returned in
the same formatting. I have an MSSQL database but the end clients are
linux w/ DBD::Sybase (FreeTDS build) and WinNT w/ DBD::ODBC.
DBD::Sybase returns dates like...'Apr 15 2002 12:00AM'
DBD::ODBC returns dates like...'2002-04-15 00:00:00.000'
I know w/ DBD::Oracle I can use an 'alter session' statement to specify
how I want dates. Is there either a way for DBI in general or specifics
for DBD::Sybase and DBD::ODBC to change default date formats?
DBD::Oracle...
$dbh->do("alter session set NLS_DATE_FORMAT = 'yyyy-mm-dd hh24:mi:ss'");
Thanks,
--
Bill McClintock - Web/Application Development
Worldcom - Colorado Springs (GOG)
vnet:622.0054 local:(719)265.0054
EMail:[EMAIL PROTECTED]
AOLIM:bm0054
