Tagged Questions
0
votes
3answers
39 views
How to form a string with parts of dates in SQL Server
I have datetimes in a table, in this manner (two in each row in a table):
Row 1: 2012-06-31 01:00:00
Row 2: 2012-06-31 02:00:00
Row 3: 2012-06-31 03:00:00
Row 4: 2012-06-31 04:00:00
...
And I want ...
0
votes
2answers
213 views
Getting SqlDateTime overflow. exception in 2008
am passing default dates (startdate & enddate) to an sp as ('1/1/1753 12:00:00 AM' & '12/31/9999 12:00:00 AM').
This was working fine in 2005, but am getting "SqlDateTime overflow. Must be ...
2
votes
1answer
803 views
Why can i insert MaxDate but not MinDate
when inserting into my table with a nullable datetime column, inserting DateTime.MinDate raises the error:
"The conversion of a char data type to
a datetime data type resulted in an
...
2
votes
1answer
541 views
SQLBulkCopy can't convert Time to DateTime
I am writing a small utility to copy a database from a proprietary ODBC database into a SQL Server database. Everything is working great, except when I use SQLBulkCopy to copy over the data. It ...
