A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
select distinct a.DateKey as CalendarDate , fx.NumeratorCurrCode as ISO_Curr , fx.SpotRate , fx.Mod_SpotRate from AdvDateList a left outer join (select NumeratorCurrCode, DenominatorCurrCode , AsOfDate, SpotRate, 1/SpotRate as Mod_SpotRate -- Mod_SpotRate from APX.FxRateHistory fx where NumeratorCurrCode in ('gb','eu') and DenominatorCurrCode = 'us' ) fx on a.DateKey = fx.AsOfDate where a.DateKey between (getdate()-6) and (getdate()-1) -- returns previous 5 days
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MySql Workbench outputting "OK" as result of queries.||5||35|
|Comparison query - 4 columns||9||42|
|query error in former passthrough query||2||33|
|Access 2010 Only Including Numbers After Certain Limit||3||8|