INSERT INTO temails (EmailID, Subject,BodyText, BodyHtml, CreatedDate, LastUpdateBy, LastUpdateByID, GroupList, Status, DeliveryDate, siteid, replyto,format,fromLabel) VALUES( , , , , , , #createodbcdatetime(now())#, , , , 0, #createodbcdatetime(createDateTime(year(arguments.emailBean.getdeliverydate()),month(arguments.emailBean.getdeliverydate()),day(arguments.emailBean.getdeliverydate()),hour(arguments.emailBean.getdeliverydate()),minute(arguments.emailBean.getdeliverydate()),0))#null, , , , ) Select * from temails where emailid= UPDATE temails set subject = , bodytext = , bodyhtml = , bodytext = , bodyhtml = , createddate = #createodbcdatetime(now())#, lastupdateby = , lastupdatebyid = , grouplist = , status = 0, deliverydate = #createodbcdatetime(createDateTime(year(arguments.emailBean.getdeliverydate()),month(arguments.emailBean.getdeliverydate()),day(arguments.emailBean.getdeliverydate()),hour(arguments.emailBean.getdeliverydate()),minute(arguments.emailBean.getdeliverydate()),0))#null, siteid= , replyto= , format= , fromLabel= where emailid = UPDATE temails SET isDeleted = 1 where emailid =