Home Forums Programming CLR Integration and Programming. SQL 2008 CLR Assembly with Permission Set Unsafe RE: SQL 2008 CLR Assembly with Permission Set Unsafe

  • May 9, 2014 at 6:04 am

    #1712122

    i'm thinking you might be able to do this in SQL, can't you?

    what am i overlooking here?

    i can get the UTC date, and datediff it agaisnt getdate(0 to get my current timezone(or any timezone if i have a table of timezone offsets), and then use DateAdd tohandle the date? then store it as a string with the offset in it?

    DECLARE @date DATETIME;

    DECLARE @offsetminutes INT

    SELECT @date = CONVERT(DATETIME,'1990-08-30 16:07:00.000'); --my kids birthday

    SELECT @offsetminutes = DATEDIFF(MINUTE,GETUTCDATE(),GETDATE()) --240 minutes for EST

    SELECT

    dateadd(minute,@offsetminutes,@date),

    CONVERT(datetimeoffset,(dateadd(minute,@offsetminutes,@date)))

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!