Always be learning. Invest in you.
Personalized learning experiences, courses taught by real-world professionals.
Start my 1-month free trial

Date- and time-related functions

From the course: SQL Essential Training

Unlock the full course today

Join today to access over 15,000 courses taught by industry experts or purchase this course individually.

Start my 1-month free trial
  • Course details

    Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.

    This course was created by Bill Weinman. We are pleased to offer this training in our library.

    Instructor

    • Bill Weinman is a tech advocate, entrepreneur, and expert in a programming languages such as C++ and Python.

      Bill Weinman is the author of several books and online courses on the technical aspects of the World Wide Web. He has earned a reputation for his ability to explain complex topics in clear, concise terms. Mr. Weinman built his first computer in 1973, and has been involved with technology ever since. He has run a successful consulting practice, been a computer manufacturer, and most recently headed a hosting company. An accomplished guitarist, Bill performs and records music when he's not writing about computers. You can learn more about Bill, his projects and his music at http://bw.org/.

      View all courses by Bill Weinman

    Skills covered in this course

  • Understanding SQL

    - Every database system has it's own set of functions specifically tasked for handling dates and times. These functions are not standardized. In this lesson, I'll show you the date and time related functions for SQLite, the system we are using for the exercises. Keep in mind that the specific functions and syntax for your system will be different. This first statement returns a timestamp, the current date and time in the UTC timezone. So I'm going to go ahead and execute that now. A timestamp is a very common usage, and every system has a convenient way of finding the current time and date. The time and date returned is in UTC, seven hours later than my local time here in the US Pacific summer timezone. SQLite does not have specific types for dates and times. SQLite uses strings, so it makes sense that it uses a special string to indicate the current time with the parameter now in the DATETIME function. Passing this string…

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
    Download the exercise files for this course. Get started with a free trial today.
  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Download on the App Store
    Get it on Google Play
    Watch this course anytime, anywhere. Get started with a free trial today.

Course Contents