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!

Day: October 7, 2017

How can I get the current time with SQL?

Good question! As you'll see below, there are some different syntax options within the different database environments current_timestamp, though,  will rarely disappoint   Happy SQL-ing!

Angelina Teneva SQL: Date Functions 7 Oct 20173 Mar 2018 0 Minutes

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
October 2017
M T W T F S S
« Sep   Nov »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

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

Powered by WordPress.com.