Re: [Emerald] SQL Script Question
Dale E. Reed Jr. ( (no email) )
Mon, 07 Jun 1999 13:40:58 -0500
Darin Spence wrote:
>
> We have a situation where a TON of payments came in and we are not going to
> be able to get them all entered and into the bank. The way our business
> process is, the guys have to stop entering payments at 3:00 PM to make the
> bank deposit. I use the Emerald Database to generate a 'deposit ticket'
> that the bank uses.
>
> Well, we would like to continue entering payments past 3:00 PM.
>
> Is there a way to modify the script below to only change the payments
> whose..
>
> Date is greater than or equal to 6/7/99 3:00 PM
>
> update payments
> set date = '6/8/99'
> where date >= '6/7/99' and date < '6/8/99'
Just add the time in there:
update payments
set date = '6/8/99'
where date >= '6/7/99 15:00' and date < '6/8/99'
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com