Converting from character to smalldatetime

x_ray · November 25th, 2005, 03:33 PM

i have a problem in converting character input into datetime or smalldatetime input.the problem is i have an asp page with javascript that sends, in query,the time in characters to the database on SQL Server 2000, but this is causing an error:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value...
although i used the convert function but it didn't work(same error),
so i cannot insert any row into database. What should i do? i need help badly on this one!:(

SqlMenace · November 25th, 2005, 03:41 PM

Is the date a valid date, are you doing validation?
How are you passing the date in, can you give an example?
Look at the range below
datetime
Date and time data from January 1, 1753 through December 31, 9999

smalldatetime
Date and time data from January 1, 1900, through June 6, 2079

âI sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

x_ray · November 26th, 2005, 06:01 AM

ok, i am using the following in the javascript,

Code:

var cdate= new Date();//gets me the current date
.
.
.
var sql="Insert into tablex values ("+cdate+")";

if i use
var sql="Insert into tablex values ('"+cdate+"')";
i get the error of conversion of characters to date time,if i use the first one a get something about variables and constants,and rejects the day part ("Thu,Fri,...."). i will try some more validation and get back to you with the results, but hope you assist me meanwhile. 10x lot