05-12-2019
Hello Neo,
Please give me some example. It will be much useful.
Thanks, Siva SQL
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am starting a process at 9 pm today and want to exit the process by 5am, the next day. Every day at 9pm the shell script will be invoked by autosys.
But how can i monitor in my script for 5 am and stop the process ?
there may be a case where the script can start at 4.59 am and... (4 Replies)
Discussion started by: risshanth
4 Replies
2. Shell Programming and Scripting
Hello All,
I was having a look on threads on the Forum about time calculation but didn't find exactly this issue.
For instance, if we have these 2 dates, begin & end :
20100430235830
20100501000200
Is there anyway, awk, ksh, perl to calculate the difference in sec and get for... (6 Replies)
Discussion started by: rany1
6 Replies
3. Shell Programming and Scripting
Hi,
Below is the backup file name (includes date & time) :
exp_trx_tables_18_Oct_2010_10_59_00.dmp
Extracted date and time from the file name as below using the below "awk"command:
date 18-Oct-2010 and time 10:59:00
echo "$fname" | awk -F"_" '{printf "Records will be restored as on... (1 Reply)
Discussion started by: milink
1 Replies
4. Shell Programming and Scripting
I have start and finish date in the following format -
Start Date: 5/21/2010 9:14:00 AM
End Date : 5/24/2010 7:23:00 AM
I need to get the time difference in the following format :mm or . Any help would be really appreciated.
Thank you! (3 Replies)
Discussion started by: randev
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am trying to use the script as under :
echo "Please input the string (APC) in the format (APC=x-yyy-z):"
read a
for i in m1 m2 m4 m5 m6
do
cat /m12/$i/12* | grep -B 1 -A 1 inaccessible | gawk '/'$a'/{print $6,$7,$8,x};{x=$3" "$4}' | awk NF > temp
cat /m122/$i/12* | grep -B 1 -A 1... (0 Replies)
Discussion started by: vanand420
0 Replies
6. Shell Programming and Scripting
I have a file wich contains time formats and i need to get the time difference
TIME1 TIME2
==================================
20120624192555.6Z 20120624204006.5Z
which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (1 Reply)
Discussion started by: wnaguib
1 Replies
7. Shell Programming and Scripting
================================================================================
Request ID GMDCOM TIME GMDRRS TIME COM-RRS
================================================================================
<36812974> Tue Oct 1 13:32:40 2013 Tue Oct 1 20:36:42 2013... (1 Reply)
Discussion started by: ghosh_tanmoy
1 Replies
8. Shell Programming and Scripting
Request ID GMDCOMTM GMDRRSTIME GMDRESTIME
<36812986> : : :I want to display the date -time difference in other fields. Above I have given for only 1 record. I want to calculate for all the records.
(GMCOMTM - GMDRRSTM) ,(GMDRRSTM-GMDRESTM) and... (5 Replies)
Discussion started by: ghosh_tanmoy
5 Replies
9. Shell Programming and Scripting
There are 2 dates,
Tue Oct 1 13:40:19 2013
Sun Sept 30 10:26:23 2013
I have multiple dates like the above one. How do I calculate the date time difference and display in another column in Shell script. Please help. (3 Replies)
Discussion started by: tanmoysays
3 Replies
10. AIX
Hi Everyone,
We are having an issue with date and date -u in our AIX Systems.
We have checked environment variable TZ and /etc/environment and however, we could not rectify the difference.
>date
Thu Mar 19 22:31:40 IST 2015
>date -u
Thu Mar 19 17:01:44 GMT 2015
Any clue... (5 Replies)
Discussion started by: madhav.kunapa
5 Replies
LEARN ABOUT DEBIAN
dbix::class::manual
DBIx::Class::Manual(3pm) User Contributed Perl Documentation DBIx::Class::Manual(3pm)
NAME
DBIx::Class::Manual - Index of the Manual
DESCRIPTION
This is the DBIx::Class users manual. DBIx::Class is a SQL->OOP mapper. This means that it can represent your SQL tables as perl classes,
and give you convenient accessors and methods for retrieving and updating information from your SQL database.
SECTIONS
DBIx::Class::Manual::FAQ
Short answers and doc pointers to questions.
DBIx::Class::Manual::Glossary
Explanations of terms used in this documentation.
DBIx::Class::Manual::Intro
Beginner guide to using DBIx::Class.
DBIx::Class::Manual::Example
An example of slightly more complex usage.
DBIx::Class::Manual::Joining
How to translate known SQL JOINs into DBIx-Class-ish.
DBIx::Class::Manual::Cookbook
Convenient recipes for DBIC usage.
DBIx::Class::Manual::Reading
How to read (and write) the reference documentation.
DBIx::Class::Manual::DocMap
Lists of modules by task to help you find the correct document.
DBIx::Class::Manual::Troubleshooting
Got trouble? Let us shoot it for you.
If you're using the CDBI Compat layer, we suggest reading the Class::DBI documentation. It should behave the same way.
DBIx::Class::Manual::Component
Existing components, and documentation and example on how to develop new ones.
perl v5.14.2 2010-09-13 DBIx::Class::Manual(3pm)