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
