date function
From: <mohitguptainfo_at_gmail.com>
Date: 7 Jan 2006 03:15:29 -0800
Message-ID: <1136632529.917919.186080_at_g14g2000cwa.googlegroups.com>
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) Received on Sat Jan 07 2006 - 12:15:29 CET
Date: 7 Jan 2006 03:15:29 -0800
Message-ID: <1136632529.917919.186080_at_g14g2000cwa.googlegroups.com>
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) Received on Sat Jan 07 2006 - 12:15:29 CET