Thanks Jon. Actually, I already had the page open, which got me as far as I've gotten. When I use
to_sql(linear_date),from_sql(sql_date_no_time)
as in your example (for expiration date), the insert for new data doesn't work, with the error:
Bad date external representation '1995 02 05 00 00 00'
): '
insert into ptk_reports
(report_id, report_text, reported_date)
values
(nextval('ptk_report_seq'), 'new post, following Jon''s ad_form', '1995 02 05 00 00 00')'
(I'm also still not getting values for existing data editing.)