Viewing 15 posts - 46 through 60 (of 191 total)
I have another hurtle... This date format: '15 Mar 2017'
I am getthing an error msg when trying to update the dates:
Conversion failed when converting date and/or time...
October 20, 2017 at 9:55 am
DesNorton,
I excluded the month > 12 and the error msg is gone.
SELECT PTL_StartDate, PTL_EndDate
INTO #Staging
FROM XLSHdr_Promo_TescoUK
WHERE (PTL_StartDate LIKE '[0-3][0-9].[0-1][0-9].[0-9][0-9][0-9][0-9]' OR PTL_StartDate LIKE...
October 19, 2017 at 12:48 pm
I think SQL Pirate is right, there could be some records with dates that have mmddyyyy instead of ddmmyyyy and this is causing the conversion failure error. I would have...
October 19, 2017 at 12:44 pm
October 19, 2017 at 11:57 am
CREATE TABLE #dates (dateString varchar(10));October 19, 2017 at 10:04 am
Ok, so i was able to get past the hurdle. It worked for me. Thanks everyone!
October 18, 2017 at 2:20 pm
CREATE TABLE #dates (dateString varchar(10));October 18, 2017 at 2:02 pm
October 18, 2017 at 12:54 pm
October 18, 2017 at 11:51 am
October 18, 2017 at 11:30 am
I created a smalldatetime column (PTL_StartDate_Dt) and I tried running this update and did not work for me:
PTL_StartDate is a varchar column with values
01/15/2017
11/22/2016
Update...
October 18, 2017 at 11:15 am
Source is what it is... I can't change that. I also don't see why the date column be updated in several parts..updating first the dd/mm/yyyy formats and then the dd.mm.yy...
October 18, 2017 at 10:27 am
This data was imported from another format. Someone else will be taking care of it before importing it into SQL. Thanks! I definitely learned something about the order of tables.
June 29, 2017 at 9:50 am
Viewing 15 posts - 46 through 60 (of 191 total)