Tags » SQL DateTime

SQL SERVER - Script to Convert Date to Julian Dates

There are many methods to store date values. One of them is Julian date. It is a seven digit number where first four is the year part and the next three digits are the number of days from Jan 01. 154 more words

SQL Authority

SQL SERVER - Quiz with DATEADD Function

How many of us use some sort of date or datetime function when working with SQL Server? I cannot think of a single developer who would ever say they don’t work with datetime conversions in their application. 403 more words

SQL Authority

SQL SERVER - The Easy Functions of SQL Server - Notes from the Field #062

: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about easy and amazing functions of SQL Server. Kathi is an amazing instructor, she was the SQL author I have read in my early career. 735 more words

SQL Authority