04-24-2011
Works great. Thank you very much.
10 More Discussions You Might Find Interesting
1. Programming
Suppose I have a table as follows:
CREATE TABLE data ( `datetime` datetime DEFAULT NOT NULL, `temperature` float DEFAULT NO NULL );
populated with temperature samples of a couple times a second.
Let's say I want to find the temperatures which are 1 second apart:
SELECT D1.datetime,... (3 Replies)
Discussion started by: figaro
3 Replies
2. 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
3. Shell Programming and Scripting
Given a time format yyyymmddmiss
201007221403
How can I add or minus minutes such that it becomes
201007221348
when I minus away 15 minutes from the time?
Also, given a time frame, let say 10 days, how do I check if a date 201006231403 that is not more than 10 days behind... (3 Replies)
Discussion started by: alienated
3 Replies
4. Shell Programming and Scripting
Hi,
I'm using awk in HP-UX machine which does not support systime(), strftime(). So to get the date time I was using :
seq 1 100000 | awk ' "date +%Y%m%d%H%M%s" | getline curtime; print curtime }'
However the above code gets the date only once, next time it is not updated. For... (2 Replies)
Discussion started by: Random_Net
2 Replies
5. 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
6. 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
7. 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
8. 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
9. UNIX for Dummies Questions & Answers
Hi All,
How do i find all the files between two times.
Eg: 26 may 2014 06:00 to 26 may 2014 14:00
mmin and mtime gives for a specific period. we receive hundreds of files input directories and i need to find how many files are received between given specific datetime.
Thanks. (2 Replies)
Discussion started by: abhi_123
2 Replies
10. 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 CENTOS
cgi::session::driver::mysql
CGI::Session::Driver::mysql(3) User Contributed Perl Documentation CGI::Session::Driver::mysql(3)
NAME
CGI::Session::Driver::mysql - CGI::Session driver for MySQL database
SYNOPSIS
$s = new CGI::Session( 'driver:mysql', $sid);
$s = new CGI::Session( 'driver:mysql', $sid, { DataSource => 'dbi:mysql:test',
User => 'sherzodr',
Password => 'hello' });
$s = new CGI::Session( 'driver:mysql', $sid, { Handle => $dbh } );
DESCRIPTION
mysql stores session records in a MySQL table. For details see CGI::Session::Driver::DBI, its parent class.
It's especially important for the MySQL driver that the session ID column be defined as a primary key, or at least "unique", like this:
CREATE TABLE sessions (
id CHAR(32) NOT NULL PRIMARY KEY,
a_session TEXT NOT NULL
);
To use different column names, change the 'create table' statement, and then simply do this:
$s = new CGI::Session('driver:mysql', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
DataSource=>'dbi:mysql:project',
});
or
$s = new CGI::Session('driver:mysql', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
Handle=>$dbh,
});
DRIVER ARGUMENTS
mysql driver supports all the arguments documented in CGI::Session::Driver::DBI. In addition, DataSource argument can optionally leave
leading "dbi:mysql:" string out:
$s = new CGI::Session( 'driver:mysql', $sid, {DataSource=>'shopping_cart'});
# is the same as:
$s = new CGI::Session( 'driver:mysql', $sid, {DataSource=>'dbi:mysql:shopping_cart'});
BACKWARDS COMPATIBILITY
As of V 4.30, the global variable $CGI::Session::MySQL::TABLE_NAME cannot be used to set the session table's name.
This is due to changes in CGI::Session::Driver's new() method, which now allows the table's name to be changed (as well as allowing both
the 'id' column name and the 'a_session' column name to be changed).
See the documentation for CGI::Session::Driver::DBI for details.
In particular, the new syntax for "new()" applies to all database drivers, whereas the old - and bad - global variable method only applied
to MySQL.
Alternately, call $session -> table_name('new_name') just after creating the session object if you wish to change the session table's name.
LICENSING
For support and licensing see CGI::Session.
perl v5.16.3 2008-07-16 CGI::Session::Driver::mysql(3)