Login     Register

        Contact Us     Search

XLeratorDB/engineering Online Documentation

SQL Server function to convert speed to feet per hour


FTHR
 
Updated: 01 December 2008 

Use FTHR to convert from feet per hour, feet per minute, feet per second, inches per second, kilometers per hour, knots, miles per hour, miles per minute, miles per second, meters per second, meters per minute, or meters per hour to feet per hour.
Syntax
SELECT [westclintech].[wct].[FTHR] (
  <@Speed, float,>
 ,<@From_scale, nvarchar(4000),>)
Arguments
@Speed
is any real number. @Speed is an expression of type float or of a type that can be implicitly converted to float
@From_scale
is the description of the units for @Speed. @From_scale must be a valid value as specified in speed unit representations@From_scale must be of a data type that is implicitly convertible to varchar.
 
Return Types
float
Remarks
·         The following table is a representation of the conversion of one of the speed units of measure into feet per hour:
feet per hour
1
feet per minute
60
feet per second
3600
inches per second
300
kilometers per hour
3280.8399
knots
6076.11549
miles per hour
5280
miles per minute
316800
miles per second
19008000
meters per second
11811.0236
meters per minute
196.850394
meters per hour
3.2808399
 
·         Conversion of meters includes all the standard prefixes with kilo representing 1,000 and yocto representing 10E-24.
Example
 
select wct.FTHR(10, 'm/s')
Here is the result set
----------------------
118110.236
 
(1 row(s) affected)


Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service