Sql-server – Date Format in Sql Server

cursorssql-server-2008

I am importing data from another sources, which has multiple columns but I am facing problem in date column like I have multiple format in this column like:

dd/mm/yyyy
mm/dd/yyyy
mmm-yyyy

Can you guide me how can accommodate these format during migrate data (using cursor to transfer data from temporary table to destination table).

How can i convert mmm-yyyy date format to dd/mm/yyyy format

Best Answer

There is no way to distinguish the meaning of 01/02/2011 and 02/01/2011 if you have this values mixed in the same column. It is that simple.

Related Solutions

Sql-server – Best way to sync a table between two sql server databases with an identity key

I would go this route:

SET IDENTITY_INSERT <table> ON
...
DBCC CHECKIDENT(<table>)
SET IDENTITY_INSERT <table> OFF

SET IDENTITY_INSERT:
http://msdn.microsoft.com/en-us/library/ms188059.aspx

DBCC CHECKIDENT:
http://msdn.microsoft.com/en-us/library/ms176057.aspx

Sql-server – bcp in of datetime type data results in an “Invalid date / time format”

I have seen this before. Ensure your datetimes are formatted like this:

yyyy-mm-ddThh:mm:ss

Example:

2011-01-18T17:30:59 would represent January 18th 2011 at 5:30:59PM

It has been a while since I ran into an issue similar to this, but I remember this being a step I took to resolve my problem.

Best Answer

Related Solutions

Sql-server – Best way to sync a table between two sql server databases with an identity key

Sql-server – bcp in of datetime type data results in an “Invalid date / time format”

Related Question