Showing posts with label DATETIME. Show all posts
Showing posts with label DATETIME. Show all posts
Thursday, February 23, 2017

SQL Server Date, Datetime and Datetime2 - What should I use when I get the value as a string?

›
When we have to store a datatime value (or date), in most cases, application accepts the value as a datetime and send the value to SQL Ser...
Saturday, December 24, 2016

SQL Server: Calculate TimeSpan using TSQL - dd:hh:mm:ss

›
While coding on my new project, wanted to show the duration between two DateTime values as a Time Span like Remaining Days : Remaining Hou...
Sunday, May 3, 2015

SQL Server Brain Basher of the Week #010 - Best way to send datetime value

›
Exchanging data between systems is not an uncommon scenario and it has become a part of most of the business. When exchanging data, the st...
Sunday, April 5, 2015

SQL Server Brain Basher of the Week #006

›
Let's talk about date and time. Have a look on following code and try to guess the value returned by last SELECT statement. USE te...
Sunday, March 15, 2015

SQL Server Brain Basher of the Week #003

›
This week Brain Basher is based on data/time. See below code and try to guess the output of it. DECLARE @datetime datetime SET @dateti...
Saturday, February 8, 2014

SQL Server DateTime data types, ranges, accuracy and default values

›
SQL Server offers different useful datetime data types for different purposes. Knowing all and their capabilities would definitely help you ...
Tuesday, February 4, 2014

SQL Server: Different ways of getting current date and time

›
What is the usual way of getting current date and time from SQL Server? Obviously, the answer is GETDATE function. Do you know that there ar...
Sunday, December 29, 2013

Best way to pass datetime values to SQL Server – SS SLUG Dec 2013 – Brain Bashers - Demo III

›
This post is related to the presentation “SQL Brain Bashers” I did at SQL Sever Sri Lanka User Group Meeting. This speaks about different wa...
Wednesday, December 25, 2013

How SQL Server interprets two-digit years as four-digit years – SS SLUG Dec 2013 – Brain Bashers - Demo II

›
This is based on the presentation titled “SQL Brain Bashers” I did at SQL Sever Sri Lanka User Group Meeting. This discusses the way SQL Ser...
Tuesday, December 24, 2013

Filtering DateTime values – SS SLUG Dec 2013 – SQL Brain Bashers - Demo I

›
This is based on the presentation titled “SQL Brain Bashers” I did at SQL Sever Sri Lanka User Group Meeting. This discusses a tricky (or er...
Thursday, March 25, 2010

What is the correct way for setting values for datetime?

›
How do we make sure that we accept values for datetime columns correctly? Has the month stored as it has been sent? Has the day stored as it...