Technical Article

Sproc to get First Day of the Month,First Weekday ETC

First Day of the Month, First Weekday, Total Days in this Month, Days In First WeeK, Days In Last Week,Total Weekend Days sample output: Given Date:Jul 16 2005 12:00AM First Day of the Month:7/1/2005 First Weekday (sun=1,sat=7):6 Total Days in this Month:31 Days In First Week:2 Days In Last Week:1 Total Weekend Days:10

You rated this post out of 5. Change rating

2005-07-15 (first published: )

224 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Tebet Barat Tlpn/wa:085373737551

By balijepalli.p

Jl. Tebet Barat IX No.40, Tebet Bar., Kec. Tebet, Kota Jakarta Selatan, Daerah Khusus...

BCA Finance - Depok Telpon/WA:08218168291

By simsctvn

BCA Finance - Depok Telpon/WA:08218168291.Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl. Ir....

BCA KCP Tebet Tlpn/Wa:6285188120691

By gQuery

Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, Tebet Bar.,...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers