Hi, I'm having trouble trying to figure out how to write a query that will give me an average of date's that I have in the database. The date is...

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

Get An Answer

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Answer

Customer
Hi, I'm having trouble trying to figure out how to write a query that will give me an average of date's that I have in the database. The date is in the following format '14-DEC-99'. Thanks For your help
Last updated
ian
Programmer
Try using SELECT CAST(AVG(CAST( as DECIMAL(20,5))) AS DATETIME) FROM as a starting point.
Posted

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

Ask Your Programming Question & Get An Answer Now!

ExpertHelp LLC is an independent provider of professional support services for third-party products and services. Any use of third-party trademarks, brand names, products and services is only referential and ExpertHelp LLC hereby disclaims any sponsorship, affiliation or endorsement of or by any such third-party.

The ExpertHelp Service should not be used as a replacement for in-person evaluations or consultations with qualified professionals, is provided for informational purposes only, and is not an emergency consultation service. No professional-client relationships are established through your use of the ExpertHelp Service. ExpertHelp does not recommend or endorse any contributor, advice, product, service, procedure, opinion, or other information that may be mentioned through the ExpertHelp Service. Any use of the term "Expert" in connection with the ExpertHelp Service is intended to describe contributors who provide answers and other content to users of the ExpertHelp Service, and not to guarantee any particular level of expertise. Such contributors are not employees of ExpertHelp or any of its affiliates, and their advice should not be relied upon as a substitute for medical, legal, veterinary, tax, financial, or other professional advice. The credentials listed in each contributor's profile are provided by that contributor and are not independently confirmed by ExpertHelp. Please see our Terms of Service for more information.

© 2024 ExpertHelp LLC. All rights reserved. ExpertHelp LLC is the owner of the EXPERTHELP℠, EXPERTHELP.COM℠, and ANSWERS YOU CAN TRUST℠ family of marks and logos and of this website's trade dress, including the overall look and feel, design properties, distinctive color combinations, typography, graphic designs, photographs and imagery.

Privacy Policy · Terms of Service · 100% Money Back Guarantee