Re: [libreoffice-users] Function WEEK in Base

On Sun, 2019-08-25 at 14:32 +0200, Harvey Nimmo wrote:
> 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

...and by the way, it makes no difference whether 2019-01-01 or 19-01-
01 the result is the same

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