No announcements
Found 3582051 threads
-
2 VotesDate Time conversion error
[Table2]; go Msg 241, Level 16, State 1, Line 18 Conversion failed when converting date and/or time from character string.Answered | 13 Replies | 1495 Views | Created by Bekis - Saturday, September 3, 2016 4:30 AM | Last reply by pituach - Saturday, September 3, 2016 4:15 PM
-
1 Votes
Date / Time Conversions
.',':')) Set @dt = replace(@dt, '00000', '') SET @dt = convert(datetime,(replace(@dt, '-', ' '))) Or alternatively as a ...Answered | 5 Replies | 1030 Views | Created by davelm42 - Friday, October 3, 2014 5:18 PM | Last reply by --CELKO-- - Friday, October 3, 2014 11:57 PM -
3 Votes
String Date conversion to Date time
Thanks for the help Regards, rdineshkumarAnswered | 4 Replies | 2471 Views | Created by Dineshkumar89 - Thursday, August 16, 2012 11:01 AM | Last reply by Dinesh Kumar Rajendran - Thursday, August 16, 2012 11:28 AM -
0 Votes
Date time Conversation
reffer to the following link it ll help http://msdn.microsoft.com/en-us/library/ms174450(SQL.100).aspx it is giving an ...Answered | 2 Replies | 2424 Views | Created by satboy_22 - Tuesday, August 31, 2010 6:54 AM | Last reply by Louis.fr - Tuesday, August 31, 2010 8:58 AM -
2 Votes
DATE TIME CONVERSION FROM NVARCHAR
Many Thanks & Best Regards, Hua MinAnswered | 12 Replies | 9239 Views | Created by srinivasa rao yenninti - Thursday, April 12, 2012 5:11 AM | Last reply by Jackson_1990 - Thursday, April 12, 2012 7:13 AM -
1 Votes
date format conversion error
Hope that helps.Answered | 5 Replies | 573 Views | Created by ananth46.reddy - Thursday, October 1, 2015 3:45 PM | Last reply by Magnus (MM8) - Saturday, October 3, 2015 10:19 AM -
5 Votes
Julian Date to Date(time) Conversion
A common situation in which this arises is Julian date as part of a file name.Answered | 10 Replies | 53143 Views | Created by Kalman Toth - Friday, February 11, 2011 10:45 PM | Last reply by - Saturday, October 27, 2018 3:36 AM -
0 Votes
Excel Data Conversion Date time
See the part of this post after the section "Serial Date Numbers from Excel" Talk to me now ...Answered | 3 Replies | 4249 Views | Created by Ajay Singh Rawat - Monday, September 10, 2012 1:20 PM | Last reply by Todd McDermid - Monday, September 10, 2012 10:50 PM -
0 Votes
Epoch time conversion to System Time and Date
Your answer focuses on the current date/time.Answered | 7 Replies | 12150 Views | Created by Mikesharp - Monday, July 12, 2010 9:21 AM | Last reply by Bruce Eitman - Friday, July 13, 2018 6:42 PM -
1 Votes
Date Time Conversion to Custom Format
Hi Ibutho, There are many great blog posts, books and articles on date and time manipulation in SQL Server.Answered | 3 Replies | 1575 Views | Created by Ibutho - Sunday, March 23, 2014 6:04 AM | Last reply by Kalman Toth - Sunday, March 23, 2014 7:18 AM -
2 Votes
DATE CONVERSION
You can CONVERT dd.mm.yyyy into a date data type using conversion 104.Answered | 10 Replies | 991 Views | Created by Phaneendra Kalapatapu - Wednesday, December 24, 2014 12:55 PM | Last reply by Visakh16 - Wednesday, December 24, 2014 5:30 PM -
5 Votes
Date Time Conversion
You need to differentiate between a given date as contained in a DateTime variable and its string representation.Answered | 7 Replies | 3274 Views | Created by Selvaraj M - Thursday, October 28, 2010 7:04 AM | Last reply by SWR1988 - Thursday, October 28, 2010 7:46 AM -
2 Votes
Date and Time Conversion
Only wish I had more time to devote to it.Answered | 4 Replies | 4117 Views | Created by CSV_GaskinML - Monday, May 24, 2010 6:47 PM | Last reply by CSV_GaskinML - Monday, May 24, 2010 9:21 PM -
0 Votes
The conversion from date to BINARY is unsupported.
Hi, If you are using JPA and Java 8, you need to have converters to deal with the new Java 8 Data Types.Answered | 3 Replies | 6278 Views | Created by teng16 - Friday, November 15, 2013 2:11 AM | Last reply by roy-silva - Tuesday, August 21, 2018 3:36 PM -
3 Votes
Date conversion failed
set @StartDate = CONVERT(date,DATEADD(day, -10, getdate())) Select @StartDate Select @StartDate = CONVERT(date,DATEADD(day, -10, ...Answered | 3 Replies | 729 Views | Created by Vinodh Selvaraj - Thursday, October 6, 2016 2:18 PM | Last reply by Tom Cooper - Thursday, October 6, 2016 2:57 PM -
0 Votes
t-sql date conversion error
Try Insert into table1 (canceldatetime) Select CONVERT(datetime,left(canceldatets,10) + space(1) + ...Answered | 3 Replies | 2405 Views | Created by sqldev1 - Wednesday, September 5, 2012 3:38 PM | Last reply by Jackson_1990 - Thursday, September 6, 2012 4:26 AM -
0 Votes
Date conversion
Hi Deepak Biswal, Thanks lot for your help its working fine.Answered | 3 Replies | 4304 Views | Created by Britekumar - Wednesday, March 17, 2010 4:35 AM | Last reply by Britekumar - Wednesday, March 17, 2010 6:11 AM -
0 Votes
String to Date conversion fail
Thanks all for the help.Answered | 6 Replies | 772 Views | Created by ShyamCharan - Thursday, January 14, 2016 10:02 AM | Last reply by MarcosLanzarini - Thursday, January 14, 2016 11:33 AM -
1 Votes
Date conversion Issue
NULL(DT_DATE) : ACCT_DT) [Derived Column [252]] Error: An error occurred while attempting to perform data conversion.Answered | 9 Replies | 8455 Views | Created by Sujn - Friday, March 26, 2010 9:54 PM | Last reply by Sujn - Monday, March 29, 2010 1:51 AM -
0 Votes
date time Conversion
and the statement would read: select [RowID]=ROW_NUMBER() over (order by b.userid), b.userid [Data Capturer's], COUNT(distinct(g.boxnumber)) [Count] from ...Answered | 4 Replies | 4070 Views | Created by Haris Hussain - Sunday, September 19, 2010 1:48 PM | Last reply by Erland Sommarskog - Sunday, September 19, 2010 5:38 PM - Items 1 to 20 of 3582051 Next ›
No announcements
