Date, Number, and String Functions
Lesson 1 of 1
  1. 1
    Date, Time and String Functions
    Oftentimes, data in columns of tables is not in the exact format we need to complete our desired analysis. We may need to extract a date from a full timestamp, manipulate a number, or combine first…
    Start
  2. 2
    Dates
    We’ll begin with dates. Dates are often written in the following format 1. Date: YYYY-MM-DD 2. Datetime or Timestamp: YYYY-MM-DD hh:mm:ss We can use SQL’s date functions to transform …
    Start
  3. 3
    Dates II
    Nice work! Now let’s assume that we have a column in our baked_goods table named manufacture_time in the format YYYY-MM-DD hh:mm:ss. We’d like to know the number of baked_goods manufactured by da…
    Start
  4. 4
    Dates III
    Given a datepart and a column of date or timestamp data type, we can increment date or timestamp values by a specified interval. For example, in SQLite, the statement DATETIME(time1, ‘+3 hours’,…
    Start
  5. 5
    Numbers
    Great work! Numeric functions can be used to transform numbers. Some common SQLite mathematical functions are included below that take numeric data types as inputs: - SELECT (number1 + number2);:…
    Start
  6. 6
    Numbers II
    A couple more useful numeric SQL functions are included below: MAX and MIN. MAX(n1,n2,n3,…): returns the greatest value in the set of the input numeric expressions MIN(n1,n2,n3,…): returns th…
    Start
  7. 7
    Strings
    String manipulation can be useful to derive information from columns. We’ll cover a couple of the common string functions here. A common use case for string manipulation in SQL is concatenation o…
    Start
  8. 8
    Strings II
    Another useful string function in SQL is REPLACE(): REPLACE(string,from_string,to_string) The function returns the string string with all occurrences of the string from_string replaced by the st…
    Start
  9. 9
    Generalizations
    Congratulations! You just learned about date, number, and string functions in SQL. What can we generalize so far? Date Functions: * DATETIME; Returns the date and time of the column specified. T…
    Start