PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Matthew dot Persico at Lazard dot com
Subject: Re: ISO8601 date formats
Date: Sep 21 2004 12:52PM

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: matthew.persico@lazard.com


                                                                                
                                                                                
                                                                                


                                                                                                                                                     
                                                                                                                                                     
                                               To:      "Sybperl-L Mailing List"                                              
              "Michael Peppler"                cc:                                                                                                   
                         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.
mpeppler@peppler.org                       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