Prisma /docs
Getting StartedORMPostgresAccelerateOptimizeGuidesPlatformAI
Query OptimizationRecommendations

Using CURRENT_TIME

Learn about the recommendation provided by Optimize for using the `CURRENT_TIME` function

The following raw SQL query uses the CURRENT_TIME function:

prisma.$queryRaw`SELECT CURRENT_TIME;`;

Why this is a problem

The CURRENT_TIME keyword returns only the time (e.g., 14:30

) without a date, making it unsuitable for tasks like logging or generating timestamps that require precise event tracking. It returns a value of type timetz, which was added for SQL standard compatibility but is generally discouraged.

Edit on GitHub

Using timestamp(0) or timestamptz(0)

Learn about the recommendation provided by Optimize for using `timestamp(0)` or `timestamptz(0)` native type.

Recordings

Learn about using Optimize's recording feature.

On this page

Why this is a problem