I wonder if there should be a YEAR_ISO function.
The VARCHAR_FORMAT function will return among other information the WEEK
according ISO guidelines as well as the appropriate YEAR of WEEK according
the ISO guidelines:
Values(VarChar_Format(YourTimestamp, 'IYYY/IW') --> Returns the ISO Year and
the week according ISO guidelines in the Format YYYY/WW.
Values(VarChar_Format(YourTimestamp, 'IYYY') --> Only returns the year for
the ISO week.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
rob@xxxxxxxxx
Gesendet: Monday, 01.12 2014 20:32
An: Midrange Systems Technical Discussion
Betreff: Re: Get Start Date of a Week Number
I wonder if there should be a YEAR_ISO function.
Keep in mind that it's possible to have dates with two different calendar
years in the same WEEK_ISO. 2014-12-31 and 2015-01-01 for example.
And it's possible to have two WEEK_ISO from totally different years like
WEEK_ISO 1 from 1997 and WEEK_ISO 1 from 2015.
I was thinking of grouping over more than one year.
... where WEEK_ISO=x and YEAR_ISO=y...
kind of thing.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
