date and time problem

[dave]

I have written asp code to insert current date and time.
my database is in sql server 2000.
this is the sql query that i m using.

sql = "INSERT INTO tblDailyVisitLog
(UserID,DailyDate,DailyTime) VALUES
('test',"&formatdatetime(date,2)&",'"&formatdatetime
(date,3)&"')"

But when I checked in the database in date and time field
it shows "1/1/1900" in both fields.

any help would be appreciated..
thanx.
david

 

[Dan Boylett]

I have written asp code to insert current date and time.
my database is in sql server 2000.
this is the sql query that i m using.

sql = "INSERT INTO tblDailyVisitLog
(UserID,DailyDate,DailyTime) VALUES
('test',"&formatdatetime(date,2)&",'"&formatdatetime
(date,3)&"')"

But when I checked in the database in date and time field
it shows "1/1/1900" in both fields.

REsponse.write your SQL statement so you can see exactly what is being
executed against the database

 

[CJM]

What date format are you using? ie where are you based? US? UK? Other?

It's always a good idea to use ISO date formats, i.e. 2004-01-15 or
20040115.

http://support.microsoft.com/?kbid=229690
http://www.aspfaq.com/show.asp?id=2260

Chris