p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_language thread: Is there any way to know the end of month?


Message #1 by "Abraham Song" <asong@n...> on Mon, 11 Dec 2000 15:08:26 -0800
Hi Friend,

Instead why don't you create a simple procedure for calculating the interest 
which get invoked automatically at the start of the month.
This procedure can be scheduled to be executed in the beginning of the 
month.

Hope this helps.

Regds,
Harsh


>From: "Gerard G Chua" <marvmarv@e...>
>Reply-To: "sql language" <sql_language@p...>
>To: "sql language" <sql_language@p...>
>Subject: [sql_language] Re: Is there any way to know the end of month?
>Date: Wed, 13 Dec 2000 22:43:56 +0800
>
>i am not sure on the commands but you can use this algo
>increment the month by 1 then go to its 1st day them minus 1
>sql language wrote:
>
> >I am going to made a stroed procedure which calculates interest at every 
>the
> >end of month.
> >Is there any way to know the end of month?
> >
> >thanks
> >
> >
> >
>
>__________________________________
>www.edsamail.com

---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com

  Return to Index