DateTime fields, methods over such fields,
DateTime depended SQL where-clause and SQL-functions.
Claudius Sailer
Claudius at sailer-online.de
Thu Dec 9 18:39:42 CST 2004
Am 09. Dez 2004 um 18:19 Uhr schrieb Ruslan Zasukhin:
> On 12/9/04 6:59 PM, "Claudius Sailer" <Claudius at sailer-online.de>
> wrote:
>
>>> 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)
>>
>> Thanks, but this is my problem. IMHO do we have several calculation
>> methods.
>
>> The US-Method says 1.1.YYYY ist week 1 using DIN week 1 ist
>> where the first thursday is in. So you can have 01.01.XXXX in week 52
>> or week 53 by DIN but week 1 in US Method. The information when is a
>> new week starting is a good thing, because US-week starts on sunday
>> and
>> by DIN on Monday.
>> But after that, what is calculationMethod in Valentina?
>
> Claudius,
>
> Please give us exact example. Ivan will check.
> Or you can check self right now with latest V4RB.
>
> Give us some date,
>
> what you get in RB
> what you get in 1.x
>
> what YOU WANT to get.
Okay can I what version of viSQL works with 2.0?
I can make an example in RB where you can see differences in US and
DIN, would this help? It is an MacOS X executable, but I can also send
code!!
thanks for help
Claudius
More information about the Valentina-beta
mailing list