I am importing a CSV into my database. There is a colum in the CSV file with what looks to be a date\time stamp, it looks like this
24/11/2011 22:03:19
I am trying to impoprt this data into a SQL table with a column that has a Varchar format which works but when i run a query the dates and times are not in order.
When I convert the table column to datetime SQL says the datetime format above is not recognised as datetime.
Can anyone help or say a way to import succesfully into a date time column?
why are you trying to store this in a varchar field? why not make the target field a datetime and then pass it in iso format (yyyymmdd hh:mm:ss) to avoid ambiguity
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Thanks for the comment. I know, it sounds very straight forward but I im importing using Powershell.
When trying to import in Powershell the default format is Varchar and if importing into a datetime column in SQL I get an error in Powershell saying cannot import Varchar into datetime column.
My plan was to stick with the import method and then run a SQL query and maybe Cast or Convert the string to a datetime format.,..
Thanks for the comment. I know, it sounds very straight forward but I im importing using Powershell.
When trying to import in Powershell the default format is Varchar and if importing into a datetime column in SQL I get an error in Powershell saying cannot import Varchar into datetime column.
My plan was to stick with the import method and then run a SQL query and maybe Cast or Convert the string to a datetime format.,..
ok. you can cast or convert as long as you're sure that format in which date values come from varchar field is consistent
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Strange datetime format
Posted - 11/30/2011 : 02:44:05
