July 21, 2022 at 11:49 am
Hello, I have a column imported from CSV (salesforce export) ) and inside sql server table column was varchar but looks like time format . 00:00:04.04.
In Salesforce Correct is to be 00000468 .How I can achieve this?
Thanks in advance,
BR,
Hadrian
July 21, 2022 at 11:53 am
Sounds like the value is also in some kind of "time format" in your CSV file then, as is the column is a varchar, presumably the value in the text file was also imported as a varchar value. The int or varchar value 00000468 wouldn't result in the time(2) value 00:00:04.04; an int can't be converted to a time, and as a varchar it wouldn't be a valid time value either.
I also have no idea how 68 becomes .04 seconds.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 21, 2022 at 12:59 pm
What is the format of the value in the CSV file? (Use a text editor, like Notepad++, to check this. Do not use Excel.)
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 23, 2022 at 4:54 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply