How to enter data and time

Hi
'd like the user to be able to enter a date and time on a form.
Currently my form only allows me to choose a date format
The datepicker functions OK.
But what is the best way for a user to be able to add a time
Any help appreciated.
Thnks
Clive

When adding a form element to the page, select Text for the field type and set the vaidation type to Time.

Originally Said By: Jason Byrnes

  When adding a form element to the page, select Text for the field type and set the vaidation type to Time.  

Thanks Jason
I think your solution will allow a time field to be set up
Iwould like the user to enter an event in a calendar so typically they would enter a title,description start and end date/time
I thought there may be a way to use datepicker to select a date and perhaps adds the time afterwards in the same field e.g 21/11/2010 09:45

Hope this makes sense and you can help
Thanks Clive

no, the date picker only allows for picking the date, you need a separate element for inputting the time.

Originally Said By: Jason Byrnes

  no, the date picker only allows for picking the date, you need a separate element for inputting the time.  

Thanks again Jason

Another question (please bear with me)

I have a table field with a which is defined as datetime in mysql.

I'm trying to get the user to enter the date and time from a form.

How would this normally be achived usingwebassist extensions?

I suppose I could set up 2 form fields
1. a date field which they could use datepicker to enter the date
2. a separate time field

How could I then amalgamate them into the into the datetime field?

Maybe I'm not even thinking along the right lines.

Any ointers really appreciated

Thanks
Clive

you have one of two ways to go:

1) Use two separate database columns, one for date, one for time.

2) Use one date time column. The issue with using the date time column is that you need to process the date / time input in 2 ways:
a) Concatenate the two values into one,
b) convert them to the MySQL Date Time YYYY-MM-DD HH:MM:SS format

My recommendation is to use 2 separate columns.