could any one tell me how to insert datetime data into SQL server2000,
i am trying the following
Insert into tablename values ('dsdf',24/11/2005 9:18,'jklj')
it keeps telling me incorrect syntax near 9. i used the GETDATE() function and it worked, but i want another way, because i want to insert the time taken from asp page using js and when using :
var cd=new Date();
var sql="Insert into tablename values ('dsdf',"+cd+")"
it keeps giving me a lengthy error about variable constants allowed and stuff. Can any body help. 10x in advance.