Hi,
i have one hard coded time which will be 23:45 and one will be sysdate (same date) and time less than 23:45.
i want to start my job at 23:45 and the input file will be arriving before that. so i want to make sure that the task starts only at 23:45 and from the input file time till 23:45... (3 Replies)
Hi All,
I know there has been a lot of things that have been written about date arithmetic, but perhaps I have missed something..
The following script takes the input from a file name fail.txt with the following format:
CLASSDB 20060328122808
CPPARMS 20060814222056
Where $1 is a file name... (4 Replies)
Hi Experts...
I want to calculate the time difference between two date-time values (using ksh). It can return the difference in hours (or whatever..)
For eg: time_diff "09/12/2009 12:30" "09/10/2009 12:30" should return 1464 hours...
$time_diff "09/12/2009 12:30:00" "09/10/2009... (5 Replies)
Hi,
I have a tab delimited file with GMT time. How to convert the GMT to PST time and store the line only if date falls to 2 days ago date.
Say today is 16, date should be of 14. or else remove the line
abc - -
efg - -
hij - -
kln - - ... (10 Replies)
Hello All,
I have a problem calculating the time difference between start and end timings...!
the timings are given by 24hr format..
Start Date : 08/05/10 12:55
End Date : 08/09/10 06:50
above values are in mm/dd/yy hh:mm format.
Now the thing is, 7th(08/07/10) and... (16 Replies)
Need some help please.
I am running SCO Openserver 5.07 on a Windows 2003 Server with VMware Server 1
If I run
# ps -ef|grep /etc/cron
the date that it shows the cron process started is older than the date I get from running the uptime command.
In other words it looks like the date... (2 Replies)
Is this way of finding the time difference a correct way of doing it or is it error-prone.
#****Check if lastrun exist. If exists check if the difference is 1 hour or not and act accordingly***********************
if ; then
lastrun_time=`cat $LOG_DIR/lastrun`
curr_time=`date +%s`
... (4 Replies)
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)
Hi Friends,
I have 2 varaibles which contain
START=`date '+ %m/%d/%y %H:%M:%S'`
END=`date '+ %m/%d/%y %H:%M:%S'`
i want the time difference between the two variables in Seconds.
Plz help. (2 Replies)
Discussion started by: i150371485
2 Replies
LEARN ABOUT OPENSOLARIS
perror
perror(1) MySQL database perror(1)NAME
perror - describes a system or MySQL error code.
SYNOPSIS
perror [OPTIONS] [ERRORCODE [ERRORCODE...]]
DESCRIPTION
Can be used to display a description for a system error code, or an MyISAM/ISAM table handler error code. The error messages are mostly
system dependent.
OPTIONS
-?|--help
Displays this help and exits.
-I|--info
Synonym for the above.
-s|--silent
Only print the error message
-v|--verbose
Print error code and message (default).
-V|--version
Displays version information and exits.
EXAMPLE
shell> perror 64 79 Error code 64: Machine is not on the network Error code 79: Can not access a needed shared library
SEE ALSO isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
lege_tables(1), mysqlshow(1), mysql_zap(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
media.com)
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 19 December 2000 perror(1)