Advanced Search

Return to Snippet

Revision: 48723
at July 8, 2011 05:09 by ezerick
Initial Code 
CREATE FUNCTION UNIX_TIMESTAMP_TO_DATETIME (
@timestamp integer
)
RETURNS datetime
AS
BEGIN
  /* Function body */
  DECLARE @return datetime

  SELECT @return = DATEADD(second, @timestamp,{d '1970-01-01'});

  RETURN @return
END
Initial URL 
http://skinn3r.wordpress.com/2009/01/26/t-sql-function-to-convert-unix-timestamp-into-ms-sql-datetime/
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
T-SQL Function to convert Unix Timestamp into MS SQL datetime « ProgAdv

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL