Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (11 Replies)
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Hi,
I've written a script to search for an Oracle ORA- error on a log file, print that line and the .trc file associated with it as well as the dateline of when I assumed the error occured. In most it is the first dateline previous to the error.
Unfortunately, this is not a fool proof script.... (2 Replies)
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
LEARN ABOUT DEBIAN
finance::quotehist::stocknod
Finance::QuoteHist::StockNod(3pm) User Contributed Perl Documentation Finance::QuoteHist::StockNod(3pm)NAME
Finance::QuoteHist::StockNod - Site-specific class for retrieving historical stock quotes.
SYNOPSIS
use Finance::QuoteHist::StockNod;
$q = Finance::QuoteHist::StockNod->new
(
symbols => [qw(IBM UPS AMZN)],
start_date => '01/01/2009',
end_date => 'today',
);
foreach $row ($q->quotes()) {
($symbol, $date, $open, $high, $low, $close, $volume) = @$row;
...
}
DESCRIPTION
Finance::QuoteHist::StockNod is a subclass of Finance::QuoteHist::Generic, specifically tailored to read historical quotes from the
StockNod web site (http://stocknod.com/).
StockNod does not currently provide information on dividends or splits.
Please see Finance::QuoteHist::Generic(3) for more details on usage and available methods. If you just want to get historical quotes and
are not interested in the details of how it is done, check out Finance::QuoteHist(3).
METHODS
The basic user interface consists of a single method, as shown in the example above. That method is:
quotes()
Returns a list of rows (or a reference to an array containing those rows, if in scalar context). Each row contains the Symbol, Date,
Open, High, Low, Close, and Volume for that date. Quote values are pre-adjusted for this site.
REQUIRES
Finance::QuoteHist::Generic
DISCLAIMER
The data returned from these modules is in no way guaranteed, nor are the developers responsible in any way for how this data (or lack
thereof) is used. The interface is based on URLs and page layouts that might change at any time. Even though these modules are designed to
be adaptive under these circumstances, they will at some point probably be unable to retrieve data unless fixed or provided with new
parameters. Furthermore, the data from these web sites is usually not even guaranteed by the web sites themselves, and oftentimes is
acquired elsewhere.
Details for StockNod's terms of use can be found here:
http://www.financialcontent.com/web2008/tos.php
If you still have concerns, then use another site-specific historical quote instance, or none at all.
Above all, play nice.
AUTHOR
Matthew P. Sisk, <sisk@mojotoad.com>
COPYRIGHT
Copyright (c) 2007-2010 Matthew P. Sisk. All rights reserved. All wrongs revenged. This program is free software; you can redistribute it
and/or modify it under the same terms as Perl itself.
SEE ALSO Finance::QuoteHist::Generic(3), Finance::QuoteHist(3), perl(1).
perl v5.12.4 2010-06-07 Finance::QuoteHist::StockNod(3pm)