Jeff Moden

  • Interests: SQL. When Im not having fun with that, then SQL. ;-)

Technical Article

Difference between dates with thousands separators

This function calculates the time difference between 2 datetimes and displays the results in the following format:H,HHH,HHH:MM:SSThe return is a 15 character field that is left padded with spaces so that the field becomes right justified.  This makes the colons line up for easy reading.  Commas are automatically added as thousands separators as needed by […]

3 (2)

2004-03-14

402 reads

Blogs

Daily Coping 19 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 18 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

By

I’ve added a new parameter to my permissions scripts (well, just the main two...

Read the latest Blogs

Forums

ssrs calculation not working

By jeannier175

I have a SSRS report that i need to calculate the Variance percent totals...

A sample of DML trigger to help you under how trigger working

By Vincent92

Comments posted to this topic are about the item A sample of DML trigger...

Azure SQL Server - consideration

By veerablog

There are a few options for Azure SQL Server Vanilla Azure SQL Server (SaaS)...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers