Timestamp to date

What is Epoch time or Unix time or POSIX time?

Unix Epoch time is the number of seconds that have elapsed since January 1, 1970, 00:00:00 UTC minus leap seconds, normally leap seconds are ignored. It is widely used in many operating systems to represent the date.

A few examples of Epoch time of some common dates.

Unix Epoch time	Date
3786912000	Sunday, January 1, 2090 00:00:00 UTC
3471292800	Monday, January 1, 2080 00:00:00 UTC
3155760000	Wednesday, January 1, 2070 00:00:00 UTC
2840140800	Thursday, January 1, 2060 00:00:00 UTC
2524608000	Saturday, January 1, 2050 00:00:00 UTC
2208988800	Sunday, January 1, 2040 00:00:00 UTC
1893456000	Tuesday, January 1, 2030 00:00:00 UTC

How to get timestamp from date?

Well, there could be many ways where you can achieve timestamp from date, here we will describe how to do it with an online conversion tool.

-- Visit this link and enter your desired date and time and optionally a timezone
-- Then hit the "Convert" button which will display corresponding timstamp value!

Now we will discuss how to get timestamp from date using some popular programming languages like C, C++, C#, Java, Python, PHP or MySQL.

1. PHP code example for date to timestamp:

<?php // set preferred timezone date_default_timezone_set('America/Los_Angeles'); // date_default_timezone_set('UTC'); // 2997993600 // output echo strtotime("01 January 2065"); // 2998022400 ?>

2. MySQL code example for date to timestamp:

-- Create table DROP TABLE IF EXISTS `timestampcheck`; CREATE TABLE `timestampcheck` ( `id` int(11) NOT NULL AUTO_INCREMENT, `myDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- insert test data INSERT INTO `timestampcheck` (`id`, `myDate`) VALUES (NULL, '2020-01-01 00:00:00'); INSERT INTO `timestampcheck` (`id`, `myDate`) VALUES (NULL, '2030-01-01 00:00:00'); -- get unix time SELECT id, UNIX_TIMESTAMP(`myDate`) ts FROM `timestampcheck`;

3. C# code example for date to timestamp:

using System; namespace FreeOnlineTools24 { public class DateToTimestamp { public static void Main(string[] args) { DateTime myDate = new DateTime (3000, 01, 01); Console.WriteLine("Unix Timestamp of date time {1} is: {0}", ConvertToUnixTime(myDate), myDate); } public static long ConvertToUnixTime(DateTime datetime) { DateTime baseDate = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc); return (long)(datetime - baseDate).TotalSeconds; } } }

How to convert timestamp to date?

Same like before if you want to do it with an online tool just follow this steps

-- Click this link and enter your Epoch time optionally a timezone like below mentioned image
-- Then hit the "Convert" button which will display human readable date!

Next, we will show how to get human readable date form Epoch time using programming languages.

1. PHP code example for timestamp to date:

<?php // set preferred timezone date_default_timezone_set('UTC'); // @var $timestamp = 32503680000; // output echo date('d M Y H:i:s', $timestamp); // 01 Jan 3000 00:00:00 ?>

2. MySQL code example for timestamp to date:

-- say, you have a table named "user" and a date column "created_on" select `id` as userId, from_unixtime(`created_on`, '%d %M %Y %H:%i:%s') as dateCreation from `user` Limit 10; -- output -- userId dateCreation -- 1 01 January 3000 00:00:00

3. C# code example for timestamp to date:

using System; namespace FreeOnlineTools24 { public class TimestampToDate { public static void Main(string[] args) { Console.WriteLine("Hello, world!"); System.DateTime myDateTime = new DateTime(1970,1,1,0,0,0,0,System.DateTimeKind.Utc); myDateTime = myDateTime.AddSeconds( 32503680000 ); Console.WriteLine(myDateTime); // 01.01.3000 00:00:00 } } }

Online timestamp converter
Happy coding!

Our free online tools

JSON decoder

Base64 image decoder encoder

Serialize and unserialize

Timestamp to date converter

Date to timestamp converter

QR code generator

App icon generator and resizer

Image converter

Image to PDF converter

RGB to HEX color converter

HEX to RGB color converter

RGB to CMYK color converter

CMYK to RGB color converter

HEX to CMYK color converter

CMYK to HEX color converter

What is my IP address

Base64 string encoder and decoder

MD5 hash generator