Solved

How can I do DATEADD in Perl?

Posted on 2012-03-28
4
398 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now