[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.
«dicembre»
domlunmarmergiovensab
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234