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

[Ivan Smahin]

Hello Claudius,

Thursday, December 9, 2004, 7:31:14 AM, you wrote:

CS> Hi,

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

CS> is it also planed to install a function/method weekoftheyear?

CS> thanks for help


CS> Claudius


It is the same to WEEK function.
 Week( date, [firstWeekDay] )
 Returns the week of year in the range of 0 - 53
 firstWeekDay == 0 - is for Sunday
 1 is for Monday and so on... up to 6 (Sat)


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua