current-time (GN020)

Automatic fix is available.

What it does

Checks for use of CURRENT_TIME function.

Why not?

It returns a value of type time with time zone.

The manual has more to say about this type:

The type time with time zone is defined by the SQL standard, but the definition exhibits properties which lead to questionable usefulness. In most cases, a combination of date, time, timestamp without time zone, and timestamp with time zone should provide a complete range of date/time functionality required by any application.

When should you?

Never.

Use instead:

Do not use the CURRENT_TIME function. Use whichever of these is appropriate:

• CURRENT_TIMESTAMP or now() if you want a timestamp with time zone,
• LOCALTIMESTAMP if you want a timestamp without time zone,
• CURRENT_DATE if you want a date,
• LOCALTIME if you want a time