[skchakri]

Hi,
I am using MSAccess 2000 as my back end.
even if i set the date field to Date/time....I am not getting the time....
I want the date format like September 23 2003 00:31:36...
can any body help me please..

[Stealth]

make sure that the time is entered into the database as well as the date

[skchakri]

Hi stealth...
First of all thanx for the response....
I am sending the date form the ASP like this
1)Query="INSERT INTO Article VALUES("
2)Query=Query & ArticleID & " , '"
3)Query=Query & Title & "' , '"
4)Query=Query & Date & "' , '"
5)Query=Query & Keywords & "' )"
look at the 5th line...i am sending the date by Date object in ASP ...
I dont know...how to send time with date....

Please help me in sending time....
If possible send me the sample peace of code too...

Thank u ..

[Stealth]

try using Now() instead of Date()