Hello everyone,
I am using the command feature inside crystal reports and I need to convert my datetime variable to central time from UTC.

I am also using parameters in this section.

SELECT [Events].[Starttime] AS StartTime

WHERE StartTime BETWEEN {?TimeStart} and {?TimeEnd}

I have the whole code but these are the tables I am looking for.

Thanks for the help!
Nick

Thanks Kevlray after googling I found this. It won't work with DST but will get me by for what I need it for.

DATEADD(second, DATEDIFF(second, GETUTCDATE(), GETDATE()), Events.Starttime) AS StartTime