Preamble
The PostgreSQL now function returns the current time and date with the time zone.
Syntax of the now function in PostgreSQL
now ( )
Parameters and function arguments
- There are no parameters or arguments for the function now.
Note:
- The function now will return the current date in ‘YYYY-MM-DD HH:MM:SS.US+TZ’ format.
The function now can be used in future versions of PostgreSQL
|
PostgreSQL 11, PostgreSQL 10, PostgreSQL 9.6, PostgreSQL 9.5, PostgreSQL 9.4, PostgreSQL 9.3, PostgreSQL 9.2, PostgreSQL 9.1, PostgreSQL 9.0, PostgreSQL 8.4.
|
Let’s look at some examples of the now function to see how to use the now function in PostgreSQL.
For example:
SELECT now();
--Result: 2019-04-23 11:57:17.177965+03
PostgreSQL: Timestamps And Dates Course
About Enteros
Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
Strengthening Financial Data Platforms with AI-Powered Database Optimization
- 24 April 2026
- Database Performance Management
The financial services industry is undergoing rapid digital transformation. From online banking and digital payments to real-time fraud detection and financial analytics, modern financial institutions rely heavily on powerful data infrastructures. Behind every financial transaction lies a complex database system that processes large volumes of data in real time. As financial platforms scale and customer … Continue reading “Strengthening Financial Data Platforms with AI-Powered Database Optimization”
Boosting E-commerce Platform Performance with AI-Driven Database Monitoring
The e-commerce industry is evolving at an unprecedented pace. From personalized shopping experiences to real-time inventory management and seamless checkout systems, modern online stores rely heavily on high-performing data infrastructures. Behind every successful e-commerce platform lies a powerful database environment that processes thousands—sometimes millions—of transactions, searches, and customer interactions every day. However, as online marketplaces … Continue reading “Boosting E-commerce Platform Performance with AI-Driven Database Monitoring”
How to Optimize Fashion Sector Growth with Enteros Database Management, AI SQL, Root Cause Analysis, and AIOps Platform
- 23 April 2026
- Database Performance Management
Introduction The fashion sector is evolving rapidly in the era of digital transformation. From fast fashion and global eCommerce platforms to personalized shopping experiences and real-time inventory systems, fashion brands are becoming increasingly data-driven. Today’s fashion companies must manage vast product catalogs, dynamic pricing strategies, omnichannel sales, and ever-changing customer preferences—all while maintaining speed, agility, … Continue reading “How to Optimize Fashion Sector Growth with Enteros Database Management, AI SQL, Root Cause Analysis, and AIOps Platform”
How to Drive Financial Sector Performance with Enteros Database Management Platform and Cloud FinOps Efficiency
Introduction The financial sector is undergoing a massive digital transformation. From real-time payments and mobile banking to AI-driven fraud detection and personalized financial services, institutions are leveraging advanced technologies to stay competitive. However, this transformation brings increasing complexity in managing IT infrastructure, ensuring high system performance, and controlling cloud costs. Financial institutions must operate in … Continue reading “How to Drive Financial Sector Performance with Enteros Database Management Platform and Cloud FinOps Efficiency”