DateTime::Format::DB2(3pm) User Contributed Perl Documentation DateTime::Format::DB2(3pm)NAME
DateTime::Format::DB2 - Parse and format DB2 dates and times
SYNOPSIS
use DateTime::Format::DB2;
my $dt = DateTime::Format::DB2->parse_timestamp( '2003-01-16-23.12.01.300000' );
# 2003-01-16-23.12.01.300000
DateTime::Format::DB2->format_timestamp($dt);
DESCRIPTION
This module understands the formats used by DB2 for its DATE, TIME, and TIMESTAMP data types. It can be used to parse these formats in
order to create DateTime objects, and it can take a DateTime object and produce a string representing it in the DB2 format.
METHODS
This class offers the following methods. All of the parsing methods set the returned DateTime object's time zone to the floating time
zone, because DB2 does not provide time zone information.
* parse_time($string)
* parse_date($string)
* parse_timestamp($string)
Given a value of the appropriate type, this method will return a new "DateTime" object. The time zone for this object will always be
the floating time zone, because by DB2 stores the local datetime, not UTC.
If given an improperly formatted string, this method may die.
* format_date($datetime)
* format_time($datetime)
* format_timestamp($datetime)
Given a "DateTime" object, this methods returns an appropriately formatted string.
SUPPORT
Support for this module is provided via the datetime@perl.org email list. See http://lists.perl.org/ for more details.
AUTHOR
Jess Robinson <castaway@desert-island.demon.co.uk>
This module was shamelessly cloned from Dave Rolsky's DateTime::Format::MySQL module.
COPYRIGHT
Copyright (c) 2005 Jess Robinson. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
datetime@perl.org mailing list
http://datetime.perl.org/
perl v5.8.8 2007-01-20 DateTime::Format::DB2(3pm)
Check Out this Related Man Page
DateTime::Format::Epoch::Unix(3pm) User Contributed Perl Documentation DateTime::Format::Epoch::Unix(3pm)NAME
DateTime::Format::Epoch::Unix - Convert DateTimes to/from Unix epoch seconds
SYNOPSIS
use DateTime::Format::Epoch::Unix;
my $dt = DateTime::Format::Epoch::Unix->parse_datetime( 1051488000 );
# 2003-04-28T00:00:00
DateTime::Format::Epoch::Unix->format_datetime($dt);
# 1051488000
my $formatter = DateTime::Format::Epoch::Unix->new();
my $dt2 = $formatter->parse_datetime( 1051488000 );
$formatter->format_datetime($dt2);
DESCRIPTION
This module can convert a DateTime object (or any object that can be converted to a DateTime object) to the number of seconds since the
Unix epoch.
METHODS
Most of the methods are the same as those in DateTime::Format::Epoch. The only difference is the constructor.
o new()
Constructor of the formatter/parser object. It has no parameters.
SUPPORT
Support for this module is provided via the datetime@perl.org email list. See http://lists.perl.org/ for more details.
AUTHOR
Eugene van der Pijll <pijll@gmx.net>
COPYRIGHT
Copyright (c) 2003 Eugene van der Pijll. All rights reserved. This program is free software; you can redistribute it and/or modify it
under the same terms as Perl itself.
SEE ALSO
DateTime
datetime@perl.org mailing list
perl v5.10.1 2007-12-03 DateTime::Format::Epoch::Unix(3pm)
Hi everyone, I hope this is the right place to ask this question...
I have a contract to convert a mainframe/DB2 application to using AIX/Oracle. Everything went fine but we are now running into a terminal problem. With the Mainframe app, the clients had great response time from remote... (5 Replies)
Hi Pals.
I have a file which is in the below format.
2007/10/15-12:04:24,'CRLift','TH-42PX75U','BestBuy','W01P0207',22,15,'User1'
2007/10/15-12:04:26,'CRLift','TH-42PX75U','BestBuy','W01P0207',22,15,'User2'
2007/10/15-12:04:29,'CRLift','TH-42PX75U','BestBuy','W01P0207',22,15,'User3'... (4 Replies)
I'm fairly new to UNIX...
I have a file which has data..
POUND
EURO
DOLLAR
....
.....
I need to compare all the entries of this file with the output i get out of a select query in DB2
This also has a lot of entries...
Should i make another file with the DB2 output and compare... (5 Replies)
Hi all
I am working in datawarehouse project and use DB2 database . shell scripting is written to connect with DB2 database in my application but i dont know how to connect with oracle databse or other databases.Is there any command in unix to connect any of these datbases? (6 Replies)
Hi All,
I have list of 100 table names in a file, how to read table name from and pass to DB2 export command and run for all tables in loop.
Please help me with script.
db2 EXPORT TO ~/data_export/<table name from file>.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.<Table Name... (4 Replies)
Hello dear friends, I have Lpar AIX 6.1 and there is DB2 installed. I have 8 Virtual CPU's configured on my Lpar and when I run nmon the CPU waiting time is always big.. I will provide screenshot for better realizing.. my question is what may produce so big waiting time?? Thanks in advance! (19 Replies)
Hi ,
I have a text file in the format
DB2:
DB2:
WB:
WB:
WB:
WB:
and a second text file of the format
Time=00:00:00.473
Time=00:00:00.436
Time=00:00:00.016
Time=00:00:00.027
Time=00:00:00.471
Time=00:00:00.436
the last string in both the text files is of the... (4 Replies)
Hi,
I would like to hear your thoughts about this. We are running our Data warehouse on DB2 DPF (partition environment) and I have notice that sometimes we hit the Asynchronous-I/O-Processes peak. DB2 relies heavily on Asynchronous I/O so I would believe this has an negative impact.We are... (10 Replies)
Hi ,
I Have following requirement:
DB2 Sql query to pass from a parameter file
for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt
How to write/modify below ksh script to... (10 Replies)
I am attempting to create a script that would allow me to list all the instances associated with a DB2 and then prompt the user to choose which one to issue the db2profile command against. I use the db2 command db2ilist to get a list of the instances for a particular server, but the number of... (7 Replies)
I have installed perl in windows.
Now I would like to install spreadsheet::xlsx & DateTime::Format::Excel modules(also few more) at a time instead of installing them seperately.
Could you please let me know how to install more than 1 module as a batch file in windows OS ?
Thanks in... (5 Replies)
I am new to AIX, but not new to the UNIX world. Recently I got a request to come with some kind of report to do the following: report if user query is using > 70% CPU (within DB2) > 5 minutes. I am by no means a DB2 guru so I do not know how to get that from within it, so I was wondering if there... (4 Replies)
Hi,
we've configured mail on DB2 data studio DSWC console. (gave mail relay server details) it used to work fine. like whenever we schedule backup jobs from DB2 side, we used to get emails after job completion.
for some reason, it stopped working now.
Please see the below info messges... (8 Replies)