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: "Matthew Persico" <matthew dot persico at gmail dot com>
Subject: Re: Retrieving datetime date into perl.
Date: Jan 13 2009 5:43AM

On Mon, Dec 29, 2008 at 12:58 PM, Jason L. Froebe  wrote:
> Check out Date::Manip :)

From experience, be careful. Some of thse are REALLY HEAVY modules and
if you create hundreds or thousands of them, you WILL slow down your
program appreciably. Test and benchmark first.

>  Jason L. Froebe
> Tech log
> MyDatabases (free) magazine:
> Froebe Fibers
> The opinions expressed within are the sole rantings of a raving lunatic and in no way reflect the rantings, fits, tantrums, errors, corrections, allocutions, or aimless thoughts of Sybase or its employees or of TeamSybase or ISUG. Any resemblence to reasonable thought, or any official or published opinion of Sybase, TeamSybase or ISUG is merely coincidental, and should be totally ignored.
> ----- Original Message ----
> From: "" 
> To: "Lenga, Yair " 
> Cc:
> Sent: Monday, December 29, 2008 7:54:24 AM
> Subject: Re: Retrieving datetime date into perl.
> I think there are a number of Date related modules on CPAN - one that
> comes to mind is DateCalc (I think).
> Michael
> "Lenga, Yair " 
> Sent by:
> 12/29/2008 02:27 PM
> To
> cc
> Subject
> Retrieving datetime date into perl.
> Hi,
> 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.
> Thanks,
> 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.

Matthew O. Persico