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.

On this page