🚨 Get Your Free NFT Certificate Mint by Completing the Web3 Exam! START NOW

Code has been added to clipboard!

How to Use SQL NOW to Retrieve Date or Time

Reading time 1 min
Published Aug 9, 2017
Updated Oct 11, 2019

SQL NOW Function: Main Tips

  • This function brings back the present date/time of the system.
  • In other systems there are various alternatives to this function/

Syntax of SQL NOW

Example
SELECT NOW() FROM tbl_name;
DataCamp
Pros
  • Easy to use with a learn-by-doing approach
  • Offers quality content
  • Gamified in-browser coding experience
  • The price matches the quality
  • Suitable for learners ranging from beginner to advanced
Main Features
  • Free certificates of completion
  • Focused on data science skills
  • Flexible learning timetable
Udacity
Pros
  • Simplistic design (no unnecessary information)
  • High-quality courses (even the free ones)
  • Variety of features
Main Features
  • Nanodegree programs
  • Suitable for enterprises
  • Paid Certificates of completion
Udemy
Pros
  • Easy to navigate
  • No technical issues
  • Seems to care about its users
Main Features
  • Huge variety of courses
  • 30-day refund policy
  • Free certificates of completion

Demo Database

The example table "Products":

ID Name Supplier_ID Category_ID Unit Price Unit_in_stock Unit_on_order
1 Cucumber 3 3 5 crates 19 17 16
2 Tomato 3 3 6 crates 20 24 Null
3 Cheese 3 4 5 kg boxes 11 11 6
4 Milk 4 4 5 L bottles 22 56 12
5 Bread 4 4 36 boxes 26 26 1

SQL NOW: Example

The code example below pick out the "Name" and "Price" for present day in the table "Products":

Example
SELECT Name, Price, Now() AS PerDate
FROM Products;

SQLite Syntax: Example

Example
SELECT Name, Price, strftime('%Y-%m-%d','now') AS PerDate
FROM Products;