Useful DateTime Functions

db_developer

Rate me:

4.00/5 (1 vote)

1 Sep 2011CPOL

IF OBJECT_ID (N'dbo.GetIntervalStartDate', N'FN') IS NOT NULL DROP FUNCTION dbo.GetIntervalStartDate;GO--gets first day of interval date belongs toCREATE FUNCTION dbo.GetIntervalStartDate (@Date datetime,@IntervalType int = 0--0 - DAY, 1 - WEEK (Mon to Sun), 2 - MONTH, 3 -...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Useful DateTime Functions

5 Mar 2015db_developer

1 alternative

Reminder.Sou...

SQL

SQL-Server

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

db_developer

Database Developer Freelancer

Ukraine

MS SQL Server Database Developer with 7+ years experience

Technologies/languages: Business Intelligence, SQL, MDX, VBA, SQL Server, Analysis Services (SSAS), Reporting services (SSRS), Integration Services (SSIS), DataWarehouse.
Also: economic background.

Feel free to contact me for rates and details.

Useful DateTime Functions

Alternatives

License

Comments and Discussions