I would like to populate a date/time field using a sql lite trigger. Update event set eventDate = DATETIME.('NOW') where id = New.Id It only updates the date but does not include the time.
Not sure what do you mean by "sql lite trigger". In Object Script trigger you can try this:
rbv_api.setFieldValue("invoice", {!id}, "eventDate", new Date());