Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).
USE [CDR_CUCM7_1_5] GO CREATE TRIGGER [dbo].[trgAfterInsert_CDR_Record] ON [dbo].[CDR] AFTER INSERT AS BEGIN DECLARE @Epoch_Date Datetime -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here SET @Epoch_Date = (SELECT i.dateTimeOrigination FROM inserted i) update [dbo].[CDR] set HumanDATETIME=dbo.fn_Epoch2HumanDate(@Epoch_Date); END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.