tag:blogger.com,1999:blog-3785927264726100043.post5919590995041755893..comments2023-03-28T11:12:38.766+03:00Comments on SQL Server, datu bāzes: Kura nedēļas diena?Jānishttp://www.blogger.com/profile/15397058091928346289noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3785927264726100043.post-63964702148716676032010-11-11T11:53:18.127+02:002010-11-11T11:53:18.127+02:00Super ideja!
To ka neērti varbūt var risināt šitā:...Super ideja!<br />To ka neērti varbūt var risināt šitā:<br />Select (6+@@DATEFIRST+DATEPART(WEEKDAY,getdate()))%7Jānishttps://www.blogger.com/profile/15397058091928346289noreply@blogger.comtag:blogger.com,1999:blog-3785927264726100043.post-75081858937850794352010-11-11T11:33:37.804+02:002010-11-11T11:33:37.804+02:00vēl jau var
select (@@DATEFIRST+DATEPART(WEEKDAY,...vēl jau var <br />select (@@DATEFIRST+DATEPART(WEEKDAY,getdate()))%7 <br />kas nu galīgi nav atkarīgs no set date first, kas var aizmirst uzlikties, ir pat gadījies.<br />Vienīgais,kas ir neērti, ka pirmdiena =2 , setdiena = 0 un svētdiena =1 <br /><br />P.S Microsoft un normāla datumu apstrāde in nepavienojamas lietas.Janis Kūlishttps://www.blogger.com/profile/14032872042656768654noreply@blogger.com