Member since 
    
	
		
		
		12-01-2016
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                2
            
            
                Posts
            
        
                0
            
            
                Kudos Received
            
        
                1
            
            
                Solution
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 7060 | 12-01-2016 10:24 PM | 
			
    
	
		
		
		12-01-2016
	
		
		10:24 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Got figured it out, below query will convert the unix time to timestamp  select from_unixtime(cast(time/1000 as bigint)) from table_1;  time is the column name 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-01-2016
	
		
		06:34 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 what is the sql query to convert unix timestamp in a column of table to julian or greg date format ? 
						
					
					... View more