No announcements
Found 3262195 threads
-
0 VotesAggregation returns Can't convert from BSON type to date Error
Changing it to new Date() returns the same error.Unanswered | 3 Replies | 2594 Views | Created by Aydrian - Thursday, May 7, 2020 9:52 PM | Last reply by Mike Ubezzi (Azure) - Sunday, May 17, 2020 3:40 AM
-
3 Votes
Converting a date string to date type
First of all, you should know that format like Apr 2017 is a String type data not a Date type in SQL Server and also can't be recoginzed as a ...Answered | 7 Replies | 1150 Views | Created by vinnie_Phantom - Friday, August 10, 2018 2:31 PM | Last reply by Xi Jin - Monday, August 13, 2018 2:28 AM -
1 Votes
Error returned Data overflow converting to the data type
The source column was date data type and during the model process it was failed with the below error The JSON DDL request failed with the following ...Answered | 3 Replies | 3388 Views | Created by Yohandy - Wednesday, November 27, 2019 8:41 AM | Last reply by Antony S - Friday, April 24, 2020 6:05 AM -
3 Votes
Formatting dates and return date type
If you absolutely must return it as a string, also return the date in another column, and then order by that.Answered | 9 Replies | 870 Views | Created by JFFernandez - Friday, January 9, 2015 9:26 AM | Last reply by Patrick Hurst - Tuesday, January 13, 2015 2:30 PM -
0 Votes
COnverting COlumn Data Type from Varchar to Date
So you may be having data that cannot be converted to date.Answered | 8 Replies | 1195 Views | Created by Subbu1082 - Tuesday, June 24, 2014 5:09 AM | Last reply by Dinesh Priyankara - Wednesday, June 25, 2014 1:02 AM -
0 Votes
Converting Date to another Date type
Kindly let me know whether the idea is possible, Catching the date from the original field, and the time ...Answered | 7 Replies | 4453 Views | Created by Radhai - Thursday, January 13, 2011 12:04 PM | Last reply by Radhai - Friday, January 14, 2011 7:29 AM -
0 Votes
Error converting data type nvarchar to date.
Check the places where you're inserting/converting value to date field like ADM_DATE_TIME etc.Answered | 3 Replies | 2964 Views | Created by lrj1985 - Wednesday, April 29, 2015 2:57 AM | Last reply by Uri Dimant - Wednesday, April 29, 2015 5:21 AM -
0 Votes
Return date from parameter
I removed the cdate and am still getting this error when OptEndDate is not null: Conversion from string "" to type 'Date' is not valid.Answered | 6 Replies | 3751 Views | Created by bschiek - Thursday, April 8, 2010 6:25 PM | Last reply by Parry2k - Thursday, April 8, 2010 8:50 PM -
0 Votes
Error converting type
Why do you have the following: Set @StartDate = (SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101)) Why do you convert ...Answered | 3 Replies | 888 Views | Created by Evil Poster - Monday, February 24, 2014 12:47 PM | Last reply by scott_morris-ga - Monday, February 24, 2014 2:03 PM -
0 Votes
Aggregate function on "large value type"
Similar thread for your reference:Answered | 2 Replies | 795 Views | Created by Rich Frenkel - Monday, April 20, 2015 7:26 PM | Last reply by Swallow0417 - Tuesday, April 21, 2015 1:58 AM -
0 Votes
Error converting data type
It throws me the following Error: Server: Msg 2715, Level 16, State 7, Line 1 Column or parameter #1: Cannot find ...Answered | 14 Replies | 10984 Views | Created by nickfinity - Thursday, July 29, 2010 4:49 PM | Last reply by Erland Sommarskog - Tuesday, December 13, 2011 11:14 PM -
2 Votes
Validation Error - Can't convert between types "DT_DBTIMESTAMP" and "DT_NUMERIC" for "NewDateEntered"
DateEntered xs:date is coming from my xml file.Answered | 4 Replies | 3870 Views | Created by encryptoras - Tuesday, January 31, 2012 10:14 PM | Last reply by encryptoras - Friday, February 3, 2012 3:25 PM -
1 Votes
Error in converting Hijri Date to Gregorian Date
[GetHijriDateId] -- SELECT dbo.GetHijriDateId('2013-02-30','k') FF ( @Date CHAR(10) ,@Type CHAR(1)='G' ) Returns INT AS BEGIN DECLARE ...Answered | 23 Replies | 7197 Views | Created by Mohamed Almogtaba Ali - Thursday, February 8, 2018 3:09 PM | Last reply by Tewie69 - Tuesday, March 17, 2020 10:45 AM -
2 Votes
Error on converting varchar to date
You may try with ISDATE function to check the Date field and then convert.Answered | 11 Replies | 4701 Views | Created by Radhai - Wednesday, December 12, 2012 3:57 AM | Last reply by Erland Sommarskog - Wednesday, December 12, 2012 8:39 AM -
2 Votes
aggregate from first avalaible date to current member.
[Caixa: càrrecs] AS Aggregate ( NULL : [Dates].Answered | 5 Replies | 2760 Views | Created by danihp - Tuesday, June 29, 2010 8:40 PM | Last reply by Darren Gosbell - Wednesday, June 30, 2010 11:13 PM -
0 Votes
Aggregation Type
[Date].Answered | 12 Replies | 4065 Views | Created by ns100 - Friday, January 15, 2010 1:37 AM | Last reply by ns100 - Friday, January 22, 2010 9:13 PM -
0 Votes
Convert Data type from Oracle Date time string to SQL Date time data type
ie., from 01-APR-11 02.15.00.026000 AM -08:00 I want 2011-04-01 02:15:00:026 with data type as date time in sql.Answered | 6 Replies | 17997 Views | Created by SamSSIS - Wednesday, February 15, 2012 6:09 PM | Last reply by arun.passioniway - Wednesday, February 15, 2012 9:03 PM -
2 Votes
Getting error while converting date
Hi Amar4sk You can use the ISDATE function to return values where the date is invalid SELECT effe_dat FROM ...Answered | 5 Replies | 6778 Views | Created by amar4sk - Tuesday, August 25, 2009 10:39 AM | Last reply by Ewan - Thursday, August 27, 2009 9:23 AM -
0 Votes
Error while convert in Date
Blank can be converted to a date declare @date varchar(8) = '' select CONVERT(DATE,@date,112) try ...Answered | 6 Replies | 6446 Views | Created by AshishSingh_DWH - Friday, October 5, 2012 8:28 AM | Last reply by Christa Kurschat - Friday, October 5, 2012 11:38 AM -
1 Votes
Converting a date into a text file into datetime type
Hi, In this scenario, you must parse "date" column (string) to get it into the correct format, and then cast that string into a date.Answered | 2 Replies | 3602 Views | Created by pscorca - Thursday, May 28, 2009 3:06 PM | Last reply by Manish Sharma - ETL - Friday, May 29, 2009 5:20 AM - Items 1 to 20 of 3262195 Next ›
No announcements
