Can somebody please tell my why the date and time will not display correctly on a page when selected from a sql server. Here is what is happening, If I select the date and time field of 10/27/2004 12:15:00 AM it will display as such, but if I use 10/27/2004 12:00:00 AM only the 10/27/2004 will display when selected, I have tried everything I can think of. If I use format it as FormatDateTime(rs("EndingTime"), 4) then just the 12:00:00 AM appears, so I know it's in the server.

this is my response.write update statement:
UPDATE TimeTracker SET StartingTime = '10/27/2004 7:00:00 PM',
EndingTime = '10/28/2004 12:00:00 AM', WhatIDid = 'asdfasdf',
Statis = 'Turned In' WHERE Task = 7;

Thanks in advance
Mike

__________________
Peace
Mike
http://www.eclecticpixel.com

me again, I was having problems accessing the database this morning so once I finally did I discovered the 12:00:00 AM is not being input, even though it is in the sql string. So that explains why the time would not display, now can anybody tell me why it will input the date but not the time.

mike

What is the datatype of that column? If that is datetime, as the name itself stands for DATE and TIME together, all values input would have DATE and TIME part in it. Either you give just DATE part as input value or both DATE and TIME parts as input. When you just specify the DATE as input, it assumes "12:00:00 AM" as its default TIME part.

So anything like "2004-10-30" is considered as "2004-10-30 12:00:00.000 AM" unless you specify the TIME part on your own.

Now the question is "Can you explain how you have extracted that on to your page?" and how you want that to be displayed on your page?

Cheers!

_________________________
- Vijay G
Strive for Perfection