DateTime saved as numeric value using SqlBulkCopy

asp.net c# interop sqlbulkcopy

Accepted Answer

I applied the subsequent:

DateTime.FromOADate(num).ToShortDateString();

where num is the date's numerical value.

0
6/23/2013 2:34:51 PM

Popular Answer

Run the following test:

SELECT CAST(CAST(YourVarcharDateColumn AS int) AS DateTime) FROM YourTable


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow