Skip to content

Jon Shaulis – Data Professional

SELECT Knowledge FROM Internet WHERE Topic = 'Data';

  • Blog Posts
  • About Me
  • Skills and Education
  • Contact Me
  • Work History
Jon Shaulis – Data Professional

Tag: ERROR

Identify and resolve “Adding a value to a ‘date’ column caused an overflow”

This is similar to my other post on how to identify conversion problems, but here’s the catch, we don’t always get a “CASE WHEN” statement or “TRY-CONVERT / CAST” function to help us! This makes it a little bit tricky to identify your problem rows, but we’ll tackle that together.

Continue reading “Identify and resolve “Adding a value to a ‘date’ column caused an overflow””

Share this:

  • Click to share on Reddit (Opens in new window) Reddit
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X
  • Click to share on Facebook (Opens in new window) Facebook
Author JonPosted on 2019-05-072020-09-16Categories CodeTags Dateadd, ERROR, T-SQLLeave a comment on Identify and resolve “Adding a value to a ‘date’ column caused an overflow”

Git and Stack

GitHub Profile

profile for Shaulinator on Stack Exchange, a network of free, community-driven Q&A sites

Disclaimer

This is my own personal blog, opinions and information contained within are my own and do not represent the policies and opinions of my employer.

Any scripts provided come as is and should be used with the appropriate level of caution.

Recent Posts

  • Hurray! I passed my 70-767 and earned my MCSE! 2020-12-16
  • Hooray! I earned my Scaled Agilist (SAFe 5) badge! 2020-10-12
  • Studying for the 70-767 to earn the MCSE 2020-05-25
  • T-SQL Tuesday #122 – Imposter Syndrome wrap up 2020-01-20
  • T-SQL Tuesday #122 – Imposter Syndrome 2020-01-07

Categories

  • Administration
  • Architecture and Design
  • Career
  • Code
  • Education
  • Performance
  • Security
  • Uncategorized
  • Blog Posts
  • About Me
  • Skills and Education
  • Contact Me
  • Work History
Jon Shaulis – Data Professional Proudly powered by WordPress