Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: michael dot x dot peppler at jpmchase dot com
Subject: Re: Retrieving datetime date into perl.
Date: Dec 29 2008 1:54PM

I think there are a number of Date related modules on CPAN - one that 
comes to mind is DateCalc (I think).


"Lenga, Yair "  
Sent by:
12/29/2008 02:27 PM



Retrieving datetime date into perl.


I apologize for posting a questions that is only 50% related to Sybase.

I'm working on a module that has to retrieve and process datetime from
Sybase. My problem is that I deal with financial data, which extended
beyond 2037 - and I can not use standard Perl measure for time (seconds
past 1970) due to 32 bit overflow.

Does anyone know of a good way to handle this problem. Ideally, I'm
looking for a module that will
- Parse dates from the format provided by DBD::Sybase.
- Allow for basic math of the dates - same as Sybase dateadd, datediff,
datepart, ...
- Support formatting similar to strftime.
- Hopefully, something that can handle dates, as well as sub-seconds
time stamp - so I have one solution for all my date processing.

Yair Lenga

This communication is for informational purposes only. It is not
intended as an offer or solicitation for the purchase or sale of
any financial instrument or as an official confirmation of any
transaction. All market prices, data and other information are not
warranted as to completeness or accuracy and are subject to change
without notice. Any comments or statements made herein do not
necessarily reflect those of JPMorgan Chase & Co., its subsidiaries
and affiliates.

This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and any
attachments are believed to be free of any virus or other defect
that might affect any computer system into which it is received and
opened, it is the responsibility of the recipient to ensure that it
is virus free and no responsibility is accepted by JPMorgan Chase &
Co., its subsidiaries and affiliates, as applicable, for any loss
or damage arising in any way from its use. If you received this
transmission in error, please immediately contact the sender and
destroy the material in its entirety, whether in electronic or hard
copy format. Thank you.

Please refer to for
disclosures relating to UK legal entities.