Search code examples
postgresqldatetimetimestampprocedurepostgresql-9.3

interval +variable PostgreSql


is there anyone at there who knows how to use a variable interval instead of a number interval in postgresql?

For example :


Solution

  • You can use make_interval()

    make_interval(days => 1, months => nbmois);