Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: omgm1ke
  • Content: Threads
  • Order by date
  1. omgm1ke

    CREATE VIEW problems

    My servers DB is using MySQL ver4.1.10. I need to use a query in the type CREATE VIEW CREATE VIEW currentCostOfStock AS SELECT P.partName, P.partNo, P.manufacturer, S.vehicleType, S.years, S.price, S.stockLevel, S.price * S.stockLevel AS productCost, SUM productCost AS stockCost FROM Parts...
  2. omgm1ke

    Average Time Query

    I have come stuck with averaging a column with type of Time. I know there is a function AVG() that I can use to filter the average of a column, however, this brings back an integer. Is there any way to return the average in time format (IE 00:00:00)? BACKGROUND INFO: SELECT `estimatedTime`...
  3. omgm1ke

    Average Time Query

    I have come stuck with averaging a column with type of Time. I know there is a function AVG() that I can use to filter the average of a column, however, this brings back an integer. Is there any way to return the average in time format (IE 00:00:00)?

Part and Inventory Search

Back
Top