Solved

How can I do DATEADD in Perl?

Posted on 2012-03-28
4
452 Views
Last Modified: 2012-04-13
I have a datetime object in Perl from MySQL database.  I want to Add x hours on this time and remove the minute and second part.  How can I do this in Perl?  Thanks.
0
Comment
Question by:thomaszhwang
  • 2
  • 2
4 Comments
 
LVL 31

Assisted Solution

by:farzanj
farzanj earned 500 total points
ID: 37779866
use DateTime;

  $dt = DateTime->new(
      year       => 1964,
      month      => 10,
      day        => 16,
      hour       => 16,
      minute     => 12,
      second     => 47,
      nanosecond => 500000000,
      time_zone  => 'Asia/Taipei',
  );

$dt->add(hours => 5)->subtract(minutes => 12)->subtract(seconds => 15);

More details:
http://search.cpan.org/~drolsky/DateTime-0.74/lib/DateTime.pm
0
 

Author Comment

by:thomaszhwang
ID: 37779887
Thanks.

Also how can I get the Minutes and Seconds of a datetime object?
0
 
LVL 31

Accepted Solution

by:
farzanj earned 500 total points
ID: 37779979
$dt->minute()
$dt->second()
0
 

Author Closing Comment

by:thomaszhwang
ID: 37845658
Thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I've just discovered very important differences between Windows an Unix formats in Perl,at least 5.xx.. MOST IMPORTANT: Use Unix file format while saving Your script. otherwise it will have ^M s or smth likely weird in the EOL, Then DO NOT use m…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question