Working with the current date and time
Because the Sakila database is a bit dated and most of the date and time values are from 2005 or 2006, you are going to practice using the current date and time in our queries without using Sakila. You'll get back into working with this database in the next video and throughout the remainder of the course. For now, let's practice the techniques you learned about so far in this chapter to work with the current date and time.
As you learned in the video, NOW() and CURRENT_TIMESTAMP can be used interchangeably.
Deze oefening maakt deel uit van de cursus
Functions for Manipulating Data in PostgreSQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select the current timestamp
SELECT ___;