Tips from the Team

Discussion List

• 
  Check if a Date Range Overlaps another Date Range

  [Deleted User] 2.1K views 0 comments 1 point Most recent by [Deleted User] April 2018
• 
  Getting the Root of a Number

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Using a Preferred Editor in VSQL

  [Deleted User] 2.1K views 0 comments 1 point Most recent by [Deleted User] April 2018
• 
  Extract Time from a Date

  [Deleted User] 4.7K views 2 comments 1 point Most recent by Jim_Knicely April 2018
• 
  Add Days to a Date, excluding SAT and SUN

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Converting Intervals to Numerics

  [Deleted User] 2.2K views 0 comments 1 point Most recent by [Deleted User] April 2018
• 
  Extract Just Numbers from a String of Characters

  [Deleted User] 2.6K views 0 comments 1 point Most recent by [Deleted User] April 2018
• 
  How old am I?

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Simulating DML Operations on External Tables

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  Summary of Cluster State

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  What’s the Maximum Column Size?

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] April 2018
• 
  What's the current status of your Vertica cluster?

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Case-Insensitive Session Queries

  [Deleted User] 3.8K views 1 comment 0 points Most recent by Jim_Knicely March 2018
• 
  Automatically Close an Idle Vertica Session

  [Deleted User] 3K views 0 comments 1 point Most recent by [Deleted User] March 2018
• 
  View an EXPLAIN Plan in JSON Format

  [Deleted User] 2.1K views 0 comments 1 point Most recent by [Deleted User] March 2018
• 
  Moved: Vertica /python

  Closed [Deleted User] 1 view 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  On-the-Fly Date Dimension

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  My SQL History

  [Deleted User] 2.5K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Parsing a String as Rows

  [Deleted User] 3.6K views 1 comment 0 points Most recent by KWillets March 2018
• 
  Getting a Word Count

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Repeating

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Splitting a String into Rows

  [Deleted User] 4.5K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Getting Every nth Row from a Table

  [Deleted User] 2.1K views 0 comments 1 point Most recent by [Deleted User] March 2018
• 
  What’s the Distance Between Two Points?

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  Keeping Track of Data Load Sources

  [Deleted User] 2K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  What's the first day of the month?

  [Deleted User] 5.3K views 0 comments 0 points Most recent by [Deleted User] March 2018
• 
  What's the last day of the month?

  [Deleted User] 2.2K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  Check the user role membership

  [Deleted User] 2.1K views 0 comments 0 points Most recent by [Deleted User] February 2018
• 
  Expiring User's Password

  [Deleted User] 4.9K views 2 comments 0 points Most recent by Jim_Knicely February 2018
• 
  vsql Shortcuts to Move Faster on the Command Line

  [Deleted User] 2.3K views 0 comments 0 points Most recent by [Deleted User] February 2018