Raimonds Simanovskis rsim

## 01_thread.rb
Thread.new do
  sleep 5
  puts "finished"
end

thread = Thread.new do
  sleep 5
  puts "finished"
end
thread.join

## gist:d11652a8336137832df9

      
        
          
            
              
              1 file
            
          
          
            
              
              1 fork
            
          
          
            
              
              4 comments
            
          
          
            
              
              6 stars
            
          
        
        
          
              
          
          
            
                rsim
                / gist:d11652a8336137832df9
            
            
              Created
              April 7, 2015 08:01
            
              
                How to get the current Unix timestamp in SQL
              
          
        
      
        
  
      
    Get the current Unix timestamp (seconds from 1970-01-01T00:00:00Z) in SQL.

MySQL: UNIX_TIMESTAMP()
PostgreSQL: CAST(EXTRACT(epoch FROM NOW()) AS INT)
MS SQL: DATEDIFF(s, '1970-01-01', GETUTCDATE())
Oracle: (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - DATE'1970-01-01') * 86400
	Thread.new do
	sleep 5
	puts "finished"
	end

	thread = Thread.new do
	sleep 5
	puts "finished"
	end
	thread.join