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

[Ruslan Zasukhin]

On 12/9/04 6:59 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>>>>        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)

Aha, yes this works in 2.0

> I have no time to test week results at the moment in methods, I want to
> wait until I can use functions.

You can in 2.0 beta. Right now

> I am not in a hurry, but it would be unusable for me to get an US-Week
> as result. 

Ivan have point that you can specify which day to consider as FIRST DAY of
week.

> 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.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------