Transact-SQL Date Format Conversions

: Joel Lipman; Transact-SQL; 19 November 2010; Hits: 10044

Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx

Error during processing - Converting Date/Time

: Joel Lipman; Transact-SQL; 13 July 2010; Hits: 13165

Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this silly mistake.

I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development Studio for all our SQL Server Analysis Service (SSAS) and Reporting Service (SSRS) projects/solutions. The features and interface are very similar when developing reports though.

The error I'd get was

An error occurred during local report processing.
An error has occurred during report processing.
Cannot read the next data row for the dataset DataSet1.
Conversion failed when converting date and/or time from character string.

Credit where Credit is Due:

Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

RSS Feed

Error during processing - Converting Date/Time (13165) Joel Lipman (Transact-SQL)
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following...
CharIndex Reverse - find occurrence starting from end of string in TSQL (40413) Joel Lipman (Transact-SQL)
What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact...
Compare two databases using T-SQL (7054) Joel Lipman (Transact-SQL)
Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two...
DataJumble - Shuffling characters in a data value (11875) Joel Lipman (Transact-SQL)
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which...
T-SQL example of Case-Sensitive Soundex (8507) Joel Lipman (Transact-SQL)
What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on...
T-SQL DateTimestamps (7734) Joel Lipman (Transact-SQL)
My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British...
Transact-SQL Date Format Conversions (10044) Joel Lipman (Transact-SQL)