phone icon 781.329.4300  ¦  Message us  ¦ Customer support login

Contact us
500 characters left

Proper Case (function)

MT platform: Client/Server, MAGIC, 6.0

This scalar TSQL function converts any text string to proper case (mixed case with initial upper case letter followed by lower case letters). Typically used to convert patient, provider, insurance names, etc. as stored in MEDITECH to a more user-friendly format.

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

Convert MT Time to Datetime (function)

MT platform: All

This scalar TSQL function returns a datetime datatype given the input of an integer stored in MEDITECH TimeID format.

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

Age in Years (function)

MT platform: All

This scalar TSQL function returns a computed age between two dates, shown to the nearest whole year.

Age in Months and Days (function)

MT platform: All

This scalar TSQL function returns a computed age between two dates, shown in whole months and days (0M 0D), typically used for infants.

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

Age in Years and Months (function)

MT platform: All

This scalar TSQL function returns a computed age between two dates, shown in whole years and months (0Y 0M). Sometimes used for pediatric patients.

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

Get end of day (function)

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.)