Skip to content

Datageeking.com

Confessions of a Data Geek

  • LinkedIn
  • Twitter
  • Pinterest
  • Goodreads
  • Tableau Public
  • Data Management
  • Data Visualization
  • Tableau
    • Tableau Public
    • Tableau: How Do I…
  • Predictive Analytics
  • SQL
    • SQL: Date Functions
    • SQL: String Functions
    • SQL: Math Functions
  • Excel
  • Excel(ling) with VBA
    • For Each Cell in Range
    • For Each Pivot Table in Pivot Tables
    • For Each Wks In Worksheets
    • For Each Wbk in Workbooks
    • For Each Table in Tables
  • VBA That SlideDeck!
    • From Excel To PowerPoint
    • Tweak In PowerPoint
  • Geek Out!

Tag: round

How do I round numbers with SQL?

Rounding functions are pretty much identical to the ones that you have, most likely, already used in Excel 2. They all have identical syntax in the DBs we've been using so far - Vertica, MySQL, SQL Server, PostgreSQL Happy SQL-ing!

Angelina Teneva SQL: Math Functions 15 Dec 20173 Mar 2018 1 Minute

About Me

  • Hey there :)

Recent Posts

  • What is the difference between….all the functions that find a substring 1st position?
  • How do I change the case of a string with SQL?
  • 10 Functions that Help you Crunch Text Strings in Excel
  • 3 Super Handy Tableau Features
  • How do I delete all of a slide content but its title with VBA?

Tags

adddate addtime add_months cast ceiling Charts concat convert current_date data databases Data Management data protection datasets dateadd datediff datepart dates date_add date_part date_trunc day dayofmonth dayofweek dayofyear DBs eomonth Excel excel-formulas extract For Each Cell in a Range For Each PT in PivotTables For Each Wbk in Wbks For Each Wks in Wbk Functions getdate iso week least() linear regression max() month multiple-pivot-tables multiple-worksheets multiple workbooks MySQL now period_add PivotCache pivot table PivotTables pivot tables PostgreSQL PowerPoint predictive analytics models protect-sheets quarter quickly round SQL SQL Server String Functions strings str_to_date subdate Tableau text_functions timestampadd timestampdiff to_date VBA vertica viz vizzes week year
March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Aug    

Archives

  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017

Read Recently

Website Powered by WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×
    Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
    To find out more, including how to control cookies, see here: Cookie Policy