Re: [firebird-support] Dates Without the Day of Month

2020-01-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.01.2020 14:18, Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote: > But how easy is it to write queries that ask for items > that are, for example, 24 months old? It can be easy but slow. It can be fast but complex. If I were you I would keep in an integer field number of

[firebird-support] Dates Without the Day of Month

2020-01-21 Thread Scott Morgan bl...@blueyonder.co.uk [firebird-support]
I need to handle some dates to a month resolution, that is the day of the month isn't important. I was thinking of having update/insert triggers to force the day of month to the 1st. But how easy is it to write queries that ask for items that are, for example, 24 months old? Scott