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

Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose

By

In this blog post, I’ve implemented two example environments for using SQL Server 2022’s...

Daily Coping 12 Aug 2022

By

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

My Toolbox - Greenshot

By

Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...

Read the latest Blogs

Forums

backup and storage questions

By Bruin

I have a 1.3 terabyte database and growing, in which 1 table a month...

Help me design a correct simple table

By freiza

I have a table like Diesel(id, supplier, operator, machine, taken_time, given_time) There are 2...

Error Grafana SQLWATCH

By abdalah.mehdoini

hello , I am looking for a Grafana expert to help me with this...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers