<div>
smalldatetime wont support 2079, change the datatype to datetime 
</div>


<div>
use datetime, rather than smalldatetime
</div>


<div>
@ It did on sql2000... Has this changed?<br />
<br />
A.
</div>


<div>
this hasn't change<br />
it did not support it on sql2000 either
</div>


<div>
Using datetime causes me the same error. The problem is that the SQL server wants the date formatted as <br />
<br />
2008/07/21<br />
<br />
When the server creates <br />
<br />
21/07/2008<br />
<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />--<br />
Microsoft OLE DB Provider for SQL Server error '80040e07' <br />
<br />
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. 
</div>


<div>
set dateformat ymd <br />
and then run the statement 
</div>


<div>
How do I do That... If I insert this code <br />
<br />
set dateformat ymd <br />
&nbsp;<br />
<br />
I get an error.<br />
<br />
A.
</div>


<div>
you should always let the server &nbsp;store the date in the format it wants and format it in your presentation layer (screen or report) the way you want. 
</div>


<div>
<div class="content wysiwyg-content">
Is there a way to specify the default date format on a specific database.<br />
<br />
I was using sql2000 and am now using sql2005. When my script tries to insert this date format:<br />
<br />
blankStartDate = &quot;1900/01/01&quot;<br />
blankEndDate = &quot;2079/06/06&quot;<br />
<br />
I egt this error.<br />
<br />
--------------------------<wbr />----------<wbr />----------<wbr />--------<br />
Microsoft OLE DB Provider for SQL Server error '80040e07' <br />
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. <br />
/grupo_gsi_adip2/VD_Editor<wbr />/WebPages/<wbr />WebPageDoF<wbr />iles/DoSav<wbr />eWebPage.a<wbr />sp, line 42 <br />
--------------------------<wbr />----------<wbr />----------<wbr />---------<br />
<br />
The server (Spanish) is rendering this format too when using the date() object. Such as <br />
<br />
&quot;LastUpDate = '&quot; &amp;&nbsp;now() &nbsp;&amp; &quot;',&quot; &amp;_ ... etc<br />
<br />
I shouyld be able to specify somewhere to use this european date format...<br />
A<br />
<br />

</div>
</div>


Is there a way to specify the default date format on a specific database.

I was using sql2000 and am now using sql2005. When my script tries to insert this date format:

blankStartDate = "1900/01/01"
blankEndDate = "2079/06/06"

I egt this error.

------------------------------------------------------
Microsoft OLE DB Provider for SQL Server error '80040e07' 
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. 
/grupo_gsi_adip2/VD_Editor/WebPages/WebPageDoFiles/DoSaveWebPage.asp, line 42 
-------------------------------------------------------

The server (Spanish) is rendering this format too when using the date() object. Such as 

"LastUpDate = '" & now()  & "'," &_ ... etc

I shouyld be able to specify somewhere to use this european date format...
A



Date format in SQL 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.