[Sql Server] Convertire da GMT

CREATE FUNCTION [dbo].[ConvertFromGMT]
(
    @dt_GMT datetime
)
RETURNS datetime
AS
BEGIN

    return  DATEADD ( hh ,  (DATEDIFF (hh , GetUTCDate(),GetDate() )) , @dt_GMT )

END

posted @ giovedì 13 marzo 2008 01:22

Print

Comments on this entry:

# re: [Sql Server] Convertire da GMT

Left by he at 13/11/2014 18:19
Gravatar
becoming fundamentally massive check my credit score product policy effectiveness 3 credit report scores evaluating rolling out 49
Comments have been closed on this topic.
«aprile»
domlunmarmergiovensab
31123456
78910111213
14151617181920
21222324252627
2829301234
567891011