SQL Server Date Conversion Issue. Importing Date problem RRS feed

  • Question

  • When I imported my database into SQL Server the Transaction Date would not import as a Date data type. I could only import the Transaction Date as a Varchar(50) data type.  It worked, but its not the format that I wanted. How do you convert a string in this database structure as a date field.  I don't understand why when I import this tsv file it won't change this date field to a date data type.  Please help.  I attached the HTML page where you can download the data file I used.  Thanks.    
    Monday, October 7, 2019 3:53 PM


All replies