No announcements
Found 4062411 threads
-
1 VotesConversion failed when converting date and/or time from character string in SQLServer
Hi Olaf,Am Getting same Error ..Answered | 11 Replies | 6587 Views | Created by RSamba - Friday, May 17, 2013 7:35 AM | Last reply by RSamba - Wednesday, May 22, 2013 7:48 AM
-
3 Votes
Conversion failed when converting date and/or time from character string
But i am doing a data migration from Sybase to SQLServer2012 using SSMA.Answered | 5 Replies | 12685 Views | Created by Balaji666 - Friday, August 16, 2013 11:35 AM | Last reply by Olaf Helper - Tuesday, August 20, 2013 12:08 PM -
0 Votes
Conversion failed when converting date and/or time from character string
In the future, it usually helps to review the actual content of the generated string before you attempt to execute it.Answered | 2 Replies | 1791 Views | Created by SAM_1983 - Tuesday, March 26, 2013 4:18 PM | Last reply by scott_morris-ga - Tuesday, March 26, 2013 5:47 PM -
0 Votes
Conversion failed when converting date and/or time from character string.
Marcus Björklund Please use "Mark As Answer" if my post has answered your question, and/or vote for it if you find it ...Answered | 2 Replies | 1678 Views | Created by .csharp - Tuesday, April 16, 2013 2:25 PM | Last reply by mbj79 - Tuesday, April 16, 2013 3:01 PM -
0 Votes
Conversion failed when converting date and/or time from character string
I think that field is not a datetime field i.e a string field.Answered | 4 Replies | 5524 Views | Created by ram1408 - Monday, September 16, 2013 11:43 AM | Last reply by --CELKO-- - Monday, September 23, 2013 2:45 AM -
1 Votes
Conversion failed when converting date and/or time from character string.
With the use of TRY_CONVERT I am not getting date as per expected , and it is not working for all rows too This is because you are using the date format ...Answered | 17 Replies | 21352 Views | Created by Vipin jha - Wednesday, January 3, 2018 2:36 PM | Last reply by A2605 - Thursday, January 4, 2018 5:30 AM -
0 Votes
Conversion failed when converting date and/or time from character string
[suggestedStockLevel] FROM (VALUES ('I001','Bacon', 'Flour', 'BaconRashers', '27/4/2015', 'Low', 'Med', 'High') ) t([ingredientCode], [name], ...Answered | 4 Replies | 1136 Views | Created by Lexes_ - Sunday, April 26, 2015 3:19 PM | Last reply by Rogge - Monday, April 27, 2015 6:45 PM -
0 Votes
Conversion failed when converting date and/or time from character string.
i did it like that sqlstr = "select excute_main.Answered | 3 Replies | 2707 Views | Created by el3ashe2 - Friday, June 17, 2011 3:15 PM | Last reply by el3ashe2 - Saturday, June 18, 2011 11:12 AM -
0 Votes
Conversion failed when converting date and/or time from character string.
your SP should get DateTime/Date/DateTime2 as input, for example.Answered | 3 Replies | 1308 Views | Created by gopal970 - Thursday, June 9, 2016 6:06 AM | Last reply by pituach - Thursday, June 9, 2016 6:38 AM -
2 Votes
conversion failed when converting date and/or time from character string
SELECT CONVERT(varchar(8), CAST(datefield as Datetime), 112) This works perfectly fine, you may have some invalid dates as the datatype is Char(24), please try to ...Answered | 5 Replies | 6351 Views | Created by SQL_Gun - Wednesday, September 5, 2012 5:46 AM | Last reply by Ahsan Kabir - Wednesday, September 5, 2012 9:53 AM -
2 Votes
Conversion failed when converting date and/or time from character string
Feel free to ask your questions and Please Note to Vote all helpful topics and Mark all answering posts.Answered | 12 Replies | 6932 Views | Created by Hennie_Ergon - Friday, March 23, 2012 9:57 AM | Last reply by arun.passioniway - Friday, March 23, 2012 11:28 AM -
0 Votes
Conversion failed when converting date and/or time from character string.
Hi IndigoMontoya, The error is caused by the data type of @params, and varchar needs to be replaced by nvarchar.Answered | 11 Replies | 747 Views | Created by IndigoMontoya - Wednesday, March 30, 2016 7:54 PM | Last reply by IndigoMontoya - Thursday, March 31, 2016 12:23 PM -
0 Votes
conversion failed when converting date and or time from character string
Naomi N, No error when i tried with 'IS NULL'.Answered | 10 Replies | 2491 Views | Created by rowter - Wednesday, May 14, 2014 3:36 PM | Last reply by Patrick Hurst - Wednesday, May 14, 2014 7:36 PM -
1 Votes
Conversion failed when converting date and/or time from character string
Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to youAnswered | 24 Replies | 1058 Views | Created by Ctrunk514 - Monday, November 16, 2015 4:11 PM | Last reply by Eshani Rao - Tuesday, November 17, 2015 10:33 PM -
0 Votes
Conversion failed when converting date and or time from character string
" Help please!!Answered | 15 Replies | 5378 Views | Created by nicole.chong - Thursday, July 28, 2011 3:28 AM | Last reply by Naomi N - Thursday, July 28, 2011 1:51 PM -
1 Votes
Conversion failed when converting date and/or time from character string.
Please Vote This As Helpful if it helps to solve your issueAnswered | 8 Replies | 1943 Views | Created by Durgavalli26 - Friday, May 15, 2015 8:18 AM | Last reply by pituach - Tuesday, June 9, 2015 9:33 PM -
0 Votes
Established query - Error Conversion failed when converting date and/or time from character string.
Thanks ------------------------------------------------------------------------------------------- Please don't forget to mark ...Answered | 5 Replies | 1371 Views | Created by bvanscoy678 - Wednesday, June 3, 2015 1:58 PM | Last reply by bvanscoy678 - Monday, June 8, 2015 9:42 PM -
0 Votes
Conversion failed when converting date and/or time from character string the following sql error
I am getting this error staright if i tried this SQL Conversion failed when converting date ...Answered | 17 Replies | 7828 Views | Created by kali786 - Friday, January 27, 2012 10:03 AM | Last reply by Erland Sommarskog - Friday, January 27, 2012 12:49 PM -
1 Votes
Conversion failed when converting date and/or time from character string
Your absurd “gender” was so bad I want to use it in a book!Answered | 5 Replies | 1085 Views | Created by S.Jitendra - Thursday, February 6, 2014 4:07 PM | Last reply by --CELKO-- - Thursday, February 6, 2014 10:10 PM -
0 Votes
SSIS Data Source redirect row which fails with error "Conversion failed when converting date and or time from character String"
Handling Errors in the Data Flow http://msdn.microsoft.com/en-us/library/ms141679(SQL.105).aspx AMBAnswered | 2 Replies | 5215 Views | Created by Nicola Celiento - Tuesday, May 25, 2010 10:17 AM | Last reply by Nicola Celiento - Wednesday, May 26, 2010 4:27 PM - Items 1 to 20 of 4062411 Next ›
No announcements
