09-13-2009
Database is MySQL indeed, overlooked that it would matter. Thanks for your elaborate answer.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm trying to use datetime.pm function in Perl. I do not have in the library. Is there a way to get it and put it into library?
Thanks,
George. (1 Reply)
Discussion started by: gpaulose
1 Replies
2. Programming
Suppose I have a mysql table consisting of measurements taken during irregular intervals as follows:
CREATE TABLE data (datetime DATETIME, value INTEGER);
mysql> SELECT datetime, value FROM data;
+---------------------+---------+
| datetime | value |... (2 Replies)
Discussion started by: figaro
2 Replies
3. Shell Programming and Scripting
Hi,
I'm trying to find processing time of my script. Please can someone give me the commands to get the start/end time in "dd-mm-yyyy hh:mm:ss" and the differnce in seconds.
Thanks! (5 Replies)
Discussion started by: dvah
5 Replies
4. Shell Programming and Scripting
Hi. I'm hoping there is a simple method where I'm able to generate a datetime string that looks like this (yyyymmddhhmm):
201106280830
The tricky part would be that I need this string to be today's datetime minus 1 year.
Is there anyway to do this? (3 Replies)
Discussion started by: buechler66
3 Replies
5. Shell Programming and Scripting
Hi,
To get the batch status, I will need to check if the particular job started after 5PM. if the job start time is before 5 pm, then it means that the job has not started for this particular date. I will run the script with date as argument.
For eg:
BS 07/10/2012
Start time from the log is... (8 Replies)
Discussion started by: ajayakunuri
8 Replies
6. Shell Programming and Scripting
Hey Guys,
I have looked for a solution throughout the forum for my particular question, but I cant find one. So I'm sorry if I overlooked it. I need to be able to 48 add hours to a particular DateTime string.
I have a variable named $startTime
I would like to be able to take that... (1 Reply)
Discussion started by: chagan02
1 Replies
7. AIX
Good day people,
Kindly advice on below please.
1) Formatting/ Arithmetic operation of given date
I understand from the AIX man date and some research that flag -d is not applicable for AIX shell scripting and some of the UNIX command date command is not available in AIX.
Please advice... (1 Reply)
Discussion started by: cielle
1 Replies
8. Shell Programming and Scripting
Hi
i need to compare the datetime between 2 columns.
SunOS 5.1 is used. Notice that mktime seems like not supported.
cat file2
P1,2012 12 4 21 36 48,2012 12 4 22 26 53
P2,2012 12 4 20 36 48,2012 12 4 21 21 23
P3,2012 12 4 18 36 48,2012 12 4 20 12 35
Below is the command used.... (1 Reply)
Discussion started by: chailee
1 Replies
9. Shell Programming and Scripting
Hello All,
I need unix command to generate a file with datetime in it.
For example :
ABC_YYYYMMDDHH24MISS.txt
Regards
Biswajeet Ghosh (1 Reply)
Discussion started by: bghosh
1 Replies
LEARN ABOUT DEBIAN
mysql::diff::table
MySQL::Diff::Table(3pm) User Contributed Perl Documentation MySQL::Diff::Table(3pm)
NAME
MySQL::Diff::Table - Table Definition Class
SYNOPSIS
use MySQL::Diff::Table
my $db = MySQL::Diff::Database->new(%options);
my $def = $db->def();
my $name = $db->name();
my $field = $db->field();
my $fields = $db->fields(); # %$fields
my $primary_key = $db->primary_key();
my $indices = $db->indices(); # %$indices
my $options = $db->options();
my $isfield = $db->isa_field($field);
my $isprimary = $db->isa_primary($field);
my $isindex = $db->isa_index($field);
my $isunique = $db->is_unique($field);
my $isfulltext = $db->is_fulltext($field);
DESCRIPTION
Parses a table definition into component parts.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
Fuller documentation will appear here in time :)
o def
Returns the table definition as a string.
o name
Returns the name of the current table.
o field
Returns the current field definition of the given field.
o fields
Returns an array reference to a list of fields.
o primary_key
Returns a hash reference to fields used as primary key fields.
o indices
Returns a hash reference to fields used as index fields.
o options
Returns the additional options added to the table definition.
o isa_field
Returns 1 if given field is used in the current table definition, otherwise returns 0.
o isa_primary
Returns 1 if given field is defined as a primary key, otherwise returns 0.
o isa_index
Returns 1 if given field is used as an index field, otherwise returns 0.
o is_unique
Returns 1 if given field is used as unique index field, otherwise returns 0.
o is_fulltext
Returns 1 if given field is used as fulltext index field, otherwise returns 0.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. 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
mysqldiff, MySQL::Diff, MySQL::Diff::Database, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff::Table(3pm)