SQL DateTime Archives - Page 4 of 29 - SQL Authority with Pinal Dave

Gouache painting of a strand of wooden beads above three small rings of beads, the middle ring holding one vermilion bead

Convert Integer to Date in SQL Server: ddMMyyyy Values

December 9, 2020

To convert integer to date values such as 09122020, split the number into day, month and year and build the date from the parts. This post compares four methods on tested data, shows why a lost leading zero and the session language break two of them, and times them on a million rows.

Three vessels retain a supplied tag, an older tag and an empty tag loop.

SQL SERVER – Capturing INSERT Timestamp in Table

November 23, 2020

Pinal Dave

SQL Tips and Tricks

SQL Constraint and Keys, SQL DateTime, SQL Scripts, SQL Server

A default can insert timestamp values when the caller omits a datetime column. I use a session-local CURRENT_TIMESTAMP example.

SET STATISTICS TIME ON – SQL in Sixty Seconds 139

October 27, 2020

Pinal Dave

SQL Video

SQL DateTime, SQL in Sixty Seconds, SQL Statistics

Do you know how long your query took to execution? Well, let us learn that today in SQL in Sixty Seconds. We will discuss SET STATISTICS TIME ON.

Gouache painting of six mugs in a row on a shelf in cream, slate blue, vermilion, sage and grey

Day Name From Date in SQL Server: DATENAME, FORMAT and More

July 27, 2020

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Finding the day name from date values takes one function, but three methods exist, and they differ on language and speed. This post compares DATENAME, FORMAT and a formula that ignores language and DATEFIRST. It measures all three on a million rows and shows how the session language changes the result.