convert the
HH24:MI:SS to total seconds?
I need to compare it to the time
in seconds on each machine.
regards,
John
-Original Message-
From: Fay Jason-W13246 [mailto:[EMAIL PROTECTED]
Sent: Friday, February 21, 2003 6:11 PM
To: Perl-Win32-Admin-Request \(E-mail\)
Subject: RE: sql statemen
27;\D+', $row);
print "Perl date is ", scalar (localtime $mydate), "\n";
}
$sth->finish;
$dbh->disconnect;
__END__
John Deretich <[EMAIL PROTECTED]>@listserv.ActiveState.com on
02/24/2003 10:17:46 AM
Sent by:[EMAIL PROTECTED]
To:"'Fay Jason
SS to total seconds?
I need to compare it to the time
in seconds on each machine.
regards,
John
-Original Message-
From: Fay Jason-W13246 [mailto:[EMAIL PROTECTED]
Sent: Friday, February 21, 2003 6:11 PM
To: Perl-Win32-Admin-Request \(E-mail\)
Subject: RE: sql statements
>Hi cliff,
>
State.com on
02/21/2003 04:31:00 PM
Sent by:[EMAIL PROTECTED]
To:"'?d Derek Douglas-Hecker'" <[EMAIL PROTECTED]>,
"Perl-Win32-Admin-Request \(E-mail\)"
<[EMAIL PROTECTED]>
cc:
Subject:RE: sql statements
I am trying to
>Hi cliff,
>
>I plugged that statement into my
>code and it's still having a problem.
>Could you take a look at my code to
>see what the problem could be:
>
>$dbh = DBI->connect("dbi:Oracle:",'username','password');
>
>my $sth = $dbh->prepare(qq{select sysdate into :mydate from dual});
>
>if ( $sth
d Derek Douglas-Hecker [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 1:25 PM
To: John Deretich
Subject: RE: sql statements
below works for meactually both statements return the same value...what
are you trying to do?
?d
use DBI;
$dbh = DBI->connect("dbi:Oracle:",&
date into :mydate from dual});
if ( $sth ) {
$sth->execute;
}
$dbh->disconnect;
regards,
John
-Original Message-
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 4:30 PM
To: John Deretich
Cc: Perl-Win32-Admin-Request \(E-mail\)
Subject: Re: sql statem
:30 PM
To: John Deretich
Cc: Perl-Win32-Admin-Request \(E-mail\)
Subject: Re: sql statements
yes and yes. you are pulling the current oracle system date from the dummy
table
dual, and loading it into a user variable. in essence, you are getting the
localtime according to the oracle system you
yes and yes. you are pulling the current oracle system date from the dummy table
dual, and loading it into a user variable. in essence, you are getting the
localtime according to the oracle system you query.
-~.-~.-~.-~.-~.-~.-~.-~.-~.-~
-~
-~ Cliff Frensley
-~ [EMAIL PROTECTED]
-~ Seattle, W
