Re: [Q] DATE - 1/2 hour ????
From: Fabio Ferrari <fferrari_at_mail.enjoy.it>
Date: 1996/10/09
Message-ID: <01bbb618$4aa331a0$1e9078c3_at_fabio>#1/1
Date: 1996/10/09
Message-ID: <01bbb618$4aa331a0$1e9078c3_at_fabio>#1/1
> I want to subtract 1/2 an hour from any given date and find the records
> between these 2 dates.
The SQL interpreter automatically convert numbers to dates:
1 is une day
1/24 is an hour
then
1/48 is a half
Your solution is
... WHERE my_date BETWEEN given_date - 1/48 AND given_date;
good luck
Bye
Fabio Ferrari
GeDInfo scrl - Italy
fferrari_at_mail.enjoy.it
Received on Wed Oct 09 1996 - 00:00:00 CEST