Forum OpenACS Development: Re: datetime widget problems

Posted by Eduardo Pérez on
I've converted to ad_form and it's now working.

I used:
  {label "Date"}
  {format "YYYY-MM-DD HH24:MI"}
  {value {$meetingdate}}}

copied from the happenings example. Where are the fields documented?

I had to use:
to_timestamp(:meetingdate,'YYYY MM DD HH24 MI SS')
to_char(meetingdate, 'YYYY MM DD HH24 MI SS') as meetingdate

to convert to sql and from sql the date format.

Is this correct?