Re: [libreoffice-users] Function WEEK in Base

On Sun, 2019-08-25 at 08:21 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> > Does anyone know why the function WEEK returns a zero for Tuesday,
> > Jan
> > 1st, 2019? i.e. WEEK('19-01-01')
>
> Must be WEEK('2019-01-01'), if you are using the internal HSQLDB.
> Gives
> '1' here.
> Must be EXTRACT(WEEK FROM CAST('2019-01-01' AS TIMESTAMP)), if you
> are
> using internal Firebird. Also the result is '1' here.
> > According to my calendar it should be week 1 and, in Calc, the
> > WEEKNUM
> > and ISOWEEKNUM both return 1. (WEEKNUM starts the week on Sunday,
> > ISOWEEKNUM on Monday, but otherwise no difference)
>
> Regards
>
> Robert
> -- 
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3

Hallo Robert,

I am using Mariadb10 as backend from a Base client via JDBC. I have
created the function within a Base Query (GUI).

Cheers
HArvey

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy