> Bill McClintock asks about different date formats, > > > 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' > > Well, this is a little off topic because the different output > formats are db config dependent in many cases. However, I've > scratched my head over it a bunch lately and here is what I've > found. Take a look at the HTTP::Date::str2time date string to > time conversion subroutine and the POSIX::strftime time to string > format subroutine. Between these two, I've been able to get most > of my date conversions to work as I needed. I've not tried the > two you asked about specifically, but that's where I'd start with > the effort. >
Or Date::Manip Jeff
