| Human readable time | Seconds |
| 1 minute | 60 seconds |
| 1 hour | 3600 seconds |
| 1 day | 86400 seconds |
| 1 week | 604800 seconds |
| 1 month (30.44 days) | 2629743 seconds |
| 1 year (365.24 days) | 31556926 seconds |
| Perl | time |
| PHP | time() |
| Ruby | Time.now (or Time.new). To display the epoch: Time.now.to_i |
| Python | import time first, then 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()) |
| MySQL | SELECT unix_timestamp(now()) |
| PostgreSQL | SELECT extract(epoch FROM now()); |
| SQL Server | SELECT DATEDIFF(s, '19700101', GETDATE()) |
| JavaScript | Math.round(new Date().getTime()/1000.0) getTime() returns time in milliseconds. |
| Unix/Linux | date +%s |
| Other OS's | Command line: perl -e "print time" (If Perl is installed on your system) |
| Perl | Use these Perl Epoch routines |
| PHP | mktime(hour, minute, second, month, day, year) |
| Ruby | Time.local(year, month, day, hour, minute, second, usec ) (or Time.gm for GMT/UTC input). To display add .to_i |
| Python | import time first, then int(time.mktime(time.strptime('2000-01-01 12:34:00', '%Y-%m-%d %H:%M:%S'))) |
| Java | long epoch = new java.text.SimpleDateFormat ("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00"); |
| VBScript/ASP | DateDiff("s", "01/01/1970 00:00:00", time field) |
| MySQL | SELECT unix_timestamp(time) Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD |
| PostgreSQL | SELECT extract(epoch FROM date('2000-01-01 12:34'));With timestamp: SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-08');With interval: SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours'); |
| SQL Server | SELECT DATEDIFF(s, '19700101', time field) |
| JavaScript | use the JavaScript Date object |
| Unix/Linux | date +%s -d"Jan 1, 1980 00:00:01" |
| Perl | Use these Perl Epoch routines |
| PHP | date(output format, epoch); Output format example: 'r' = RFC 2822 date |
| Ruby | Time.at(epoch) |
| Python | import time first, then time.gmtime(epoch) time is an array of year, month, day, hour, min, sec, day of week, day of year, DST |
| Java | String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date (epoch*1000)); |
| VBScript/ASP | DateAdd("s", epoch, "01/01/1970 00:00:00") |
| PostgreSQL | SELECT TIMESTAMP WITH TIME ZONE 'epoch' + epoch * INTERVAL '1 second'; |
| MySQL | from_unixtime(epoch, optional output format) The default output format is YYY-MM-DD HH:MM:SS |
| SQL Server | DATEADD(s, epoch, '19700101') |
| JavaScript | use the JavaScript Date object |
| Linux | date -d @1190000000 (replace 1190000000 with your epoch, needs newer version of date) |
| Other OS's | Command line: perl -e "print scalar(localtime(epoch))" (If Perl is installed) Replace 'localtime' with 'gmtime' for GMT/UTC time. |
Full screen epoch clock | Epoch Conversion Functions | Related Books
Esta página en Español: Convertir Epochs / Tiempos Unix
Please note: All tools on this page are based on the time settings of your computer.