DateTime fields, methods over such fields, DateTime depended SQL where-clause and SQL-functions.

[Claudius Sailer]

Hi Ruslan,

Am 09. Dez 2004 um 08:52 Uhr schrieb Ruslan Zasukhin:

>> Am 09. Dez 2004 um 01:15 Uhr schrieb Ivan Smahin:
>>
>>>        Strict usage of such keywords must be only in methods'
>>> predicates based on
>>>         datetime-literals.
>>>
>>>
>>>      3. There is powerful set of datetime SQL-functions in Valentina 
>>> 2.
>>>         I would say this is a most powerful set in DBMS world.
>>
>> is it also planed to install a function/method weekoftheyear?
>
> I am sure this function was in Valentina 1.x also.
> Right ?
>
> And yes it exactly exists in 2.0.
>
> I need upload PDF with all functions from 2.0

sorry that I tried to asked this.
You can see other eMail from me that problem is not so trivial. At the 
moment I don't use methods, because I am waiting for functions in 
SQL-Statement like

SELECT WEKKOFYEAR(date)

I have no time to test week results at the moment in methods, I want to 
wait until I can use functions.
I am not in a hurry, but it would be unusable for me to get an US-Week 
as result. Because than I have same result as in RealBasic and have to 
write my own function, where I didn't have the speed I would sugest 
from valentina.

bye



Claudius

-- 
G4/733 QS / MacOS X 10.3.5de / RB 5.5.3de/ Valentina 1.10.0
Homepage    http://www.ClaSai.de
Download    finale Versionen, Betaversionen auf der Homepage
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]