Unix time stamp in: C++, C#, JAVA, Python, PHP, Javascript, MySQL, Oracle, PostgresSQL, Snowflake, PowerShell, Unix time on Wikipedia.org
Recent dates
| Date | Unix timestamp |
|---|---|
| Now | 1791078231 |
| 1 hour ago | 1791074631 |
| 2 hours ago | 1791071031 |
| 3 hours ago | 1791067431 |
| 6 hours ago | 1791056631 |
| 12 hours ago | 1791035031 |
| 1 day ago | 1790991831 |
| 2 days ago | 1790905431 |
| 3 days ago | 1790819031 |
| 1 week ago | 1790473431 |
| 2 weeks ago | 1789868631 |
| 3 weeks ago | 1789263831 |
| 4 weeks ago | 1788659031 |
| 1 month ago | 1788486231 |
| 2 months ago | 1785807831 |
| 3 months ago | 1783129431 |
| 6 months ago | 1775267031 |
| 9 months ago | 1767494631 |
| 1 year ago | 1759542231 |
| 2 years ago | 1728006231 |
| 3 years ago | 1696383831 |
| 5 years ago | 1633311831 |
| 10 years ago | 1475545431 |
Upcoming dates
| Date | Unix timestamp |
|---|---|
| Now | 1791078231 |
| In 1 hour | 1791081831 |
| In 2 hours | 1791085431 |
| In 3 hours | 1791089031 |
| In 6 hours | 1791099831 |
| In 12 hours | 1791121431 |
| In 1 day | 1791164631 |
| In 2 days | 1791251031 |
| In 3 days | 1791337431 |
| In 1 week | 1791683031 |
| In 2 weeks | 1792287831 |
| In 3 weeks | 1792892631 |
| In 4 weeks | 1793497431 |
| In 1 month | 1793760231 |
| In 2 months | 1796352231 |
| In 3 months | 1799030631 |
| In 6 months | 1806803031 |
| In 9 months | 1814665431 |
| In 1 year | 1822614231 |
| In 2 years | 1854236631 |
| In 3 years | 1885772631 |
| In 5 years | 1948844631 |
| In 10 years | 2106697431 |
How to get current timestamp in Java
Here is an example how you can get current timestamp in Java
Java
import java.sql.Timestamp;
import java.util.Date;
public class CurrentTimeStamp {
public static void main(String[] args) {
Date date = new Date();
System.out.println(new Timestamp(date.getTime()));
}
}
Output
How to get current timestamp in C++
Here is an example how you can get current timestamp in C++
C++
#include <stdio.h>
#include <time.h>
int main()
{
time_t now;
now = time(NULL);
printf("Current unix time is %d", now);
return 0;
}
Execution
#include <stdio.h>
#include <time.h>
int main ()
{
time_t rawtime;
struct tm * timeinfo;
time (&rawtime);
timeinfo = localtime (&rawtime);
printf ("Current local time and date: %s", asctime(timeinfo));
return 0;
}
Execution
How to get current timestamp in c#
Here is an example how you can get current timestamp in c#
Option 1
DateTimeOffset.UtcNow.ToUnixTimeSeconds()
Option 2
DateTimeOffset now = DateTimeOffset.Now;
long timestamp = now.ToUnixTimeMilliseconds();
Option 3
DateTime currentDateUtc = DateTime.UtcNow.Date;
string formattedDate = currentDate.ToString("yyyy-MM-dd")
How to get current timestamp in Python
Here is an example how you can get current timestamp in Python
import time
import datetime
print "Current unix time: %s" %time.time()
print "Current date and time: " , datetime.datetime.now()
Output
How to get current timestamp in PHP
Here is an example how you can get current timestamp in PHP
echo time();
How to get current timestamp in Javascript
Here is an example how you can get current timestamp in Javascript
var timestamp = new Date().getTime();
document.write(timestamp);
Output
How to get current timestamp in MySQL
Here is an example how you can get current timestamp in MySQL
CREATE TABLE `mytable` (
`id` int(11) NOT NULL,
`text` varchar(100) NOT NULL,
`epoch` int(11) NOT NULL
);
Option 1
CREATE TABLE `mytable` (
`id` int(11) NOT NULL,
`text` varchar(100) NOT NULL,
`epoch` int(11) NOT NULL
);
INSERT INTO mytable
VALUES(1,'hello',UNIX_TIMESTAMP('2026-10-03 21:43:51'))
Option 2
INSERT INTO mytable
VALUES(1,'hello',UNIX_TIMESTAMP(now()))
Option 3
VALUES(1,'hello',UNIX_TIMESTAMP('1791078231'))
SELECT FROM_UNIXTIME(1791078231);
How to get current timestamp in Oracle
Here is an example how you can get current timestamp in Oracle
Option 1
SELECT SYSTIMESTAMP FROM DUAL;
Option 2
SELECT CURRENT_TIMESTAMP FROM DUAL;
How to get current timestamp in PostgreSQL
Here is an example how you can get current timestamp in PostgreSQL
Option 1
SELECT NOW();
Option 2
SELECT CURRENT_TIMESTAMP;
How to get current timestamp in snowflake
Here is an example how you can get current timestamp in snowflake
Option 1
SELECT CURRENT_TIMESTAMP();
Option 2
SELECT CURRENT_TIME();
How to get current timestamp in PowerShell
Here is an example how you can get current timestamp in PowerShell
Option 1
Get-Date
Option 2
Get-Date DisplayHint Date
Option 3
Get-Date -Format "dddd MM/dd/yyyy HH:mm K"
Option 4
Get-Date -UnixTimeSeconds 1791078231
Love ToolsYEP? Support our Work!
Buy us a coffee