Tag Archives: datetime

Interesting observation with DATETIMEOFFSET data type in SQL

Posted on November 6, 2017 by vijred

Calculating daily max values of a table will be different if you are using/storing the data in DATETIMEOFFSET format. Basic difference is, while comparing the data between DATETIMEOFFSET and DATE (or DATETIME), DATETIMEOFFSET value will be converted to UTC and … Continue reading →

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , , | Leave a comment

Frequently used Windows Operating System commands

Posted on May 21, 2015 by vijred

Different commands in windows operating system I user frequently • How to find the Serial Number of Laptop/ Server/ System • Check who logged in remote Server and kill other user sessions • Search for some text in file: • … Continue reading →

Posted in commands | Tagged , , , , , , , , , , , , , , , , | Leave a comment

Maximum and Minimum values that DATETIME data type can store…

Posted on September 18, 2014 by vijred

Maximum value: 9999-12-31 23:59:59.997 Minimum value: 1753-01-01 00:00:00.000 Yes, I am referring to SQL Server  -Vijred

Posted in SQL | Tagged , | Leave a comment

SSIS – Connection Manager – Dynamic Connection string – Connection String with date and time

Posted on April 3, 2014 by vijred

This Blog explains how to dynamically generate Connection string! I had a requirement to push the data to a file in specific folder but the file name should contain Date and Time. To address the requirement, I had to generate … Continue reading →

Posted in Productivity, SQL, SSIS | Tagged , , , , , , , | Leave a comment