Hi!

If I understand right, period can be selected with

select * from table where date_field between 'date1' and 'date2'.

Is there any easy way to get records within one month, or should I
explicitly write, eg. for september:

select * from table where date_field between '1.9.2004' and '30.9.2004'
??

Same question will apply to select within one week or one year.


If this is only possible with explicit dates, any hints would be
apprechiated, how to get first/last day of current week, month using borland
products (CBuilder, Delphi) or API calls.

Sorry, if this is a little off-topic for this list.


Regards,
Primoz