How To Get The Current Epoch Time (Unix Timestamp)

  • PHP
  • PostgreSQL
  • powershell
  • Python
  • ruby
  • shell
  • sql server
  • unix
  • Unix Timestamp
  • vbscript

  • Perl:
time
  • PHP:
time()
  • Ruby:
Time.now # (or Time.new). To display the epoch: Time.now.to_i
  • Python:
import time # first, then int(time.time())
  • Java:
long epoch = System.currentTimeMillis()/1000;
  • Microsoft .NET C#:
epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000;
  • VBScript/ASP:
DateDiff("s", "01/01/1970 00:00:00", Now())
  • Erlang:
calendar:datetime_to_gregorian_seconds(calendar:now_to_universal_time( now()))-719528*24*3600. # OR element(1, now()) * 10000 + element(2, now()).
  • MySQL:
SELECT unix_timestamp(now())
  • PostgreSQL:
SELECT extract(epoch FROM now());
  • Oracle PL/SQL:
SELECT (SYSDATE - TO_DATE('01-01-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) * 24 * 60 * 60 FROM DUAL
  • SQL Server:
SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
  • JavaScript:
Math.round(new Date().getTime()/1000.0) // getTime() returns time in milliseconds.
  • Unix/Linux Shell:
date +%s
  • PowerShell:
Get-Date -UFormat "%s" # Produces: 1279152364.63599
  • Actionscript:
(new Date()).time
  • Other OS’s Command line:
perl -e "print time" # (If Perl is installed on your system)
  • ColdFusion (CFML) MX 6.1+:
#int( getTickCount() / 1000 )#
  • Bash Command Line:
date +%s

How to Identify Your Linux Distribution and Version with Simple Commands

If you are using a Linux-based operating system and you want to know which specific distribution and version you have installed, there is a simple command that can help you with that. Just open a terminal window and type the following:

cat /etc/issue

This will display the name and the release number of your Linux distribution. For example, if you are using Debian 4.0, the output will look like this:

Debian GNU/Linux 4.0 \n \l

The \n and \l are special characters that represent the current date and the name of the terminal device, respectively. They are not part of the distribution name.