Thanks, Hank!
I figured it was something like that, but couldn't see any clear documentation
on the Oracle reference page on date/time functions.
On Sep 30, 2011, at 8:22 PM, Hank wrote:
> n Fri, Sep 30, 2011 at 11:08 PM, Jan Steinman wrote:
>> Okay, I've reviewed the online man page for date
2011/09/30 20:08 -0700, Jan Steinman
Okay, I've reviewed the online man page for date and time functions, and I've
played with several likely candidates, and I am still having trouble
subtracting two arbitrary Datetimes to get something that is useful. A simple
subtraction yields the l
n Fri, Sep 30, 2011 at 11:08 PM, Jan Steinman wrote:
> Okay, I've reviewed the online man page for date and time functions, and I've
> played with several likely candidates, and I am still having trouble
> subtracting two arbitrary Datetimes to get something that is useful. A simple
> subtracti
Okay, I've reviewed the online man page for date and time functions, and I've
played with several likely candidates, and I am still having trouble
subtracting two arbitrary Datetimes to get something that is useful. A simple
subtraction yields the least useful thing possible: a modulo-100 differ
On 16.02.2001 13:27:58 Vyacheslav Chukin wrote:
> Please, tell me,
> how could I determine,
> which one of two datetime values is greater?
Date1 < Date2
> In other words,
> how could I determine,
> is stored on db datetime value in future or past?
Past:
DbDateTime < NOW()
Present:
DbDateT
select if(columnname > now(), "future", "past") from tblname
On Fri, 16 Feb
2001, Vyacheslav Chukin wrote:
> Please, tell me,
> how could I determine,
> which one of two datetime values is greater?
>
> In other words,
> how could I determine,
> is stored on db datetime value in future or pas
Please, tell me,
how could I determine,
which one of two datetime values is greater?
In other words,
how could I determine,
is stored on db datetime value in future or past?
Best regards, mailto:[EMAIL PROTECTED]
Vyacheslav Chukin
---
