Re: date function

mohitguptainfo_at_gmail.com wrote:
> hi all, i want to write a query in sql that gives me the name of the
> previous month from current date and then check that month name in
> another table 'MNTH' and then update a field 'days' in 'MNTH' table to
> an integer value (which is nothing but the number of days in that month)

Just enumerate it in the function.
The fact that your data is table shaped is not a good reason to put it in a database table. Put there what your users need to maintain. Received on Sat Jan 07 2006 - 13:05:44 CET