Re: ISO8601 date formats
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase |
|---|---|
| Message-ID | <OFDC9D59E4.36726C2F-ON85256F16.00468DF1-85256F16.0046F067@lazard.com> |
Allow both, with different switches. There is no "default" to pick. -- Matthew Persico Vice President Lazard 30 Rockefeller Plaza New York, NY 10020, USA Phone Number: 212 632 8255 Fax Number: 212 332 5904 Email: [email protected] To: "Sybperl-L Mailing List" <[email protected]> "Michael Peppler" cc: <[email protected]> Subject: ISO8601 date formats Sent by: owner-sybperl-l@peppler. org 21 Sep 2004 08:47 AM I'm thinking of adding support for conversion to ISO8601 date/time formats to DBD::Sybase. The Sybase conversion routines don't understand this format (yet), so I'd roll my own (which is easy enough). Is this interesting to folks on this list? If so, do you prefer the fully compliant version 2004-08-21T14:36:48.080Z or something that is close but maybe a little more readable (e.g. 2004-08-21 14:36:48.080). Note that Sybase has no concept of timezones, so the fully-compliant conversion simply assumes UTC (which might of course be very incorrect!). The alternative is to assume the timezone of the client, but there is of course no guarantee that the client and the server run in the same timezone! Michael -- Michael Peppler Data Migrations, Inc. [email protected] http://www.peppler.org/ Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.peppler.org/resume.html