Technical Article

WorkingDaysDiff complementary UDF for DATEDIFF

We frequently have to work out a date based on a number of working days before or after a specified date, excluding Saturdays and Sundays.Attached is the script to create the function.  I call another function called fn_Midnight which was designed to help whe programmers get a date with no time portion without having to […]

You rated this post out of 5. Change rating

2002-10-22

491 reads

Blogs

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters

By

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

A New Word: La Guadière

By

la guadière – n. a glint of goodness you notice in something that you...

Read the latest Blogs

Forums

BCA KCP Ngawi | Tlp/Wa:0817866887

By Layanan Bank BCA

Tlp/Wa_Cs:0817-866-887. Jl. PB. Sudirman No. 74 RT 003 RW 002, Kec. Ngawi, Kab. Ngawi...

Converting Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Converting Money

non ascii columns in a utf-8 .txt file

By stan

hi, we couldnt get our upstream data source developers to supply what is sometimes...

Visit the forum

Question of the Day

Converting Money

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;

See possible answers