I have a site with asp pages-mysql database. I have constructed pages for insert, update, delete records with the built-in

application objects of Dreamweaver.

The site displays some records based on the date I have inserted.
I insert the date as following: year/month/day.

Now I am thinking of being able to insert some records based not only in date but in time additionally.

How can I insert date and time successfully to a record, so the page I want would display the record the specific time I

have already given? Something like year/month/day & [time]?

What datatype are you using for that column? If you use DATETIME datatye, that has got timestamp included with it.

(YYYY-MM-DD HH:MM:SS)

That should help you.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Thanks for your response.

Seems to work! I am testing it.

When I give only date and no time, it is supposed to be the 24:00:00, the beginning of the new day?

Its actually 00:00:00, but essentially, yes, that's correct.

Take it easy,
Dan