phone icon 781.329.4300  ¦  Message us  ¦ Customer support login ¦ Product documentation

  1. You are here:  
  2. Home
  3. DR Network
  4. TSQL code
  5. Get end of day (function)

Welcome to the DR Network.

The DR Network has everything you need to get started building reports with Data Repository, including T-SQL stored procedures and functions, SSRS report definition files, and even Report Designer reports. Everything is free to the MT community and available for every MT version from MAGIC to Expanse. Sign up today!
Contact us
500 characters left

Get end of day (function)

TSQL code
  • MT platform: All

This scalar TSQL function calculates the last second of a given day (23:59:59) when passed a date in mm/dd/yyyy format. Useful for getting to the end of a day on reports that prompt the user for a date range.

(Read our blog for more information about user-defined functions in T-SQL.)

  To download this report, please log in or create an account. → 

fn get end of day