Passing tstzrange to postgres in EF Core using
DateTime algus = DateTime.Parse("2024-11-25T00:00:00+02:00", CultureInfo.InvariantCulture).ToUniversalTime();
DateTime lopp = DateTime.Parse("2025-01-25T22:00:00+02:00", CultureInfo.InvariantCulture).ToUniversalTime();
await ctx.Database.SqlQuery<DateTime>($@"
select lower(tstzrange({algus},{lopp},'[)')) as ""Value""
").ToArrayAsync();
throws error
invalid input syntax for type timestamp with time zone: "@p0" at character 20
STATEMENT: select tstzrange '[@p0,@p1)'
How to pass tstzrange to Postgres ?
Code is in ASP.NET 9 MVC controller
Application uses Postgres 12 and later server
and latest Npgsql Entity Framework Core Provider
1