quote: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.
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?
- Vijay G
Strive for Perfection