Thanks for the reply. Problem is that US uses Sunday! Problem I'm hitting is not DAYOFWEEK buy rather WEEKOFYEAR - eg report showing this/last week.
Can do it programmatically if necessary, but do you know of a workaround similar to one you suggested for DAYOFWEEK? Cheers, David Jeroen Boomgaardt <[EMAIL PROTECTED]>@listserv.sap.com on 02/06/2003 03:11:44 PM Please respond to Jeroen Boomgaardt <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: Internationalized dates (and mysql difference)? According to ISO/R 2015-1971, DIN 1355 and ISO 8601, a week starts with Monday, so SAP's choice seems logical. But if you want it differently, you could use something like DAYOFWEEK(t) MOD 7 + 1 Regards, Jeroen Boomgaardt On Monday, June 2, 2003 at 8:08:19 PM, [EMAIL PROTECTED] wrote: > Hi, > > Is there any way to internationalize dates? > > Specifically, it appears that SAP uses Monday as the first day of the week, > and we have been used to Sunday being the first day. > > Interestingly enough, MySQL uses SUNDAY as the first day of the week too - > hmmmm, wonder what's going to happen there!!! > > Cheers, > > David _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
