1. GeniusConnect support
  2. Database
  3. Views
  4. How To convert UTC datetime to a LocalTime
Administrator
  •  Admin
  • Advanced Member Topic Starter
2007-08-14T23:35:00Z
We want to load meeting data from our SQL Server database
to Exchange public Calendar folder.
Our database stores meeting "start time" as UTC datetime.

When meetings are loaded from DB to Outlook, there is 4 hour difference.


How can we create a VIEW to convert the start time to local Outlook time?
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
  •  Admin
  • Advanced Member Topic Starter
2007-08-14T23:37:00Z
Hi,

you can use DATEADD function to add 4 hours to the start value.

Please see example based on GeniusConnect SQL Server Example table:

CREATE VIEW dbo.UTCConversionExampleView
AS
SELECT     DATEADD([Hour], 4, gc_Start) AS UTCtoLocalStartTime, *
FROM         dbo.Calendar
Administrator
2021-02-19T10:09:00Z
GeniusConnect built-in UTC and other date-time conversions:
https://www.geniusconnec...WebHelp/Dateandtime.html 
 Atom Feed Rss Feed
Similar Topics
  1. GeniusConnect support
  2. Database
  3. Views
  4. How To convert UTC datetime to a LocalTime