Missing TIME in Access 2003

i'm trying fill access 2003 date/time field date , time data using following code:

-form-
<cfset datetime = createodbcdatetime(now())>
<cfinput type="hidden" name="createddatetime" value="#datetime#">
-endform-

-actionpage-
<cfinsert datasource="intranet" tablename="alerts" formfields="alertid, isalertcolor, alerttext, begindatetime, enddatetime, createddatetime, createdip, createduser">
-endactionpage-

this code returns:

{ts '2007-05-14 14:52:11'}

however, in access 2003, looks this:

5/14/2007


i'm capturing begindatetime, enddatetime , createddatetime , *need* hh:mm in fields. how go this?

i'm not sure why care displays in ms access, assume have web front end db.
but,
that's because "display" format indicated in ms access.

you need open db, select column contains date.
then @ bottom of window there values can set, in there there format
click on down arrow , select need.
ken

More discussions in Database Access

adobe