14 Utc Time

UTC/GMT+14 is 14 hours ahead of Greenwich Mean Time (GMT). The GMT/UTC offset for Samoa during Daylight Saving Time (DST), is +14 hours. Line Islands, part of the Kiribati republic, have this offset all year round. Both places can boast of being the first places where a new day starts. Find out more about other time zone using our geographical selector. UTC stands for Universal Time. MST is known as Mountain Standard Time. MST is 6 hours behind UTC. So, when it is it will be. Other conversions: UTC to Paris Time, UTC to Dubai Time, UTC to Rome Time, UTC to Dublin Time. Getting Started. 1 Add locations (or remove, set home, order) 2 Mouse over hours to convert time at a glance 3 Click hour. Meeting Planner for UTC+14; Time Zone Converter for UTC+14; Event Time Announcer for UTC+14; Time difference between UTC+14 and other locations; Display a free clock for UTC+14 on your website or blog; More about UTC Time Zone Abbreviations.


2018 January 7

Coordinated Universal Time (UTC), also referred to as Greenwich Mean Time (GMT), Universal Time (UT), or 'Zulu' is an international time scale used in astronomical and aviation publications, weather products, and other documents. UTC uses 24-hour (military) time notation and is based on the local standard time on the 0° longitude meridian which runs through Greenwich, England. Midnight in Greenwich corresponds to 00:00 UTC, noon corresponds to 12:00 UTC, and so on.

UTC Conversion Table

The following table provides a convenient way to convert between UTC and U.S. and Canadian time zones1.

PSTPDTMSTMDTCSTCDTESTEDTUTC
4 p.m.5 p.m.5 p.m.6 p.m.6 p.m.7 p.m.7 p.m.8 p.m.00:00
5 p.m.6 p.m.6 p.m.7 p.m.7 p.m.8 p.m.8 p.m.9 p.m.01:00
6 p.m.7 p.m.7 p.m.8 p.m.8 p.m.9 p.m.9 p.m.10 p.m.02:00
7 p.m.8 p.m.8 p.m.9 p.m.9 p.m.10 p.m.10 p.m.11 p.m.03:00
8 p.m.9 p.m.9 p.m.10 p.m.10 p.m.11 p.m.11 p.m.Midnight04:00
9 p.m.10 p.m.10 p.m.11 p.m.11 p.m.MidnightMidnight1 a.m.05:00
10 p.m.11 p.m.11 p.m.MidnightMidnight1 a.m.1 a.m.2 a.m.06:00
11 p.m.MidnightMidnight1 a.m.1 a.m.2 a.m.2 a.m.3 a.m.07:00
Midnight1 a.m.1 a.m.2 a.m.2 a.m.3 a.m.3 a.m.4 a.m.08:00
1 a.m.2 a.m.2 a.m.3 a.m.3 a.m.4 a.m.4 a.m.5 a.m.09:00
2 a.m.3 a.m.3 a.m.4 a.m.4 a.m.5 a.m.5 a.m.6 a.m.10:00
3 a.m.4 a.m.4 a.m.5 a.m.5 a.m.6 a.m.6 a.m.7 a.m.11:00
4 a.m.5 a.m.5 a.m.6 a.m.6 a.m.7 a.m.7 a.m.8 a.m.12:00
5 a.m.6 a.m.6 a.m.7 a.m.7 a.m.8 a.m.8 a.m.9 a.m.13:00
6 a.m.7 a.m.7 a.m.8 a.m.8 a.m.9 a.m.9 a.m.10 a.m.14:00
7 a.m.8 a.m.8 a.m.9 a.m.9 a.m.10 a.m.10 a.m.11 a.m.15:00
8 a.m.9 a.m.9 a.m.10 a.m.10 a.m.11 a.m.11 a.m.Noon16:00
9 a.m.10 a.m.10 a.m.11 a.m.11 a.m.NoonNoon1 p.m.17:00
10 a.m.11 a.m.11 a.m.NoonNoon1 p.m.1 p.m.2 p.m.18:00
11 a.m.NoonNoon1 p.m.1 p.m.2 p.m.2 p.m.3 p.m.19:00
Noon1 p.m.1 p.m.2 p.m.2 p.m.3 p.m.3 p.m.4 p.m.20:00
1 p.m.2 p.m.2 p.m.3 p.m.3 p.m.4 p.m.4 p.m.5 p.m.21:00
2 p.m.3 p.m.3 p.m.4 p.m.4 p.m.5 p.m.5 p.m.6 p.m.22:00
3 p.m.4 p.m.4 p.m.5 p.m.5 p.m.6 p.m.6 p.m.7 p.m.23:00

To illustrate how to convert UTC to local time, assume that an event will occur on Wednesday at 06:00 UTC and you want to convert this to PDT. Using the UTC conversion table, you can see that 06:00 UTC Wednesday translates to 11 p.m. PDT Tuesday.

14 Utc Time

Sources of UTC

UTC is available via Internet, radio, telephone, and the Global Positioning System (GPS).

Internet

UTC provided by the U.S. National Institute of Standards and Technology (NIST) and the U.S. Naval Observatory is available online at the Official U.S. Time page. Note that the accuracy of the displayed time may vary depending on the type and speed your Internet connection.

Radio

Several radio stations worldwide transmit precise time signals2. However, only a few provide voice announcements indicating the current UTC. NIST continuously broadcasts time signals with voice announcements over shortwave radio from stations WWV in Fort Collins, Colorado and WWVH in Kauai, Hawaii. Both stations transmit on 2.500, 5.000, 10.000, and 15.000 MHz. WWV also operates on 20.000 MHz.

Canada's Institute for National Measurement transmits time signals and voice announcements over radio station CHU in Ottawa, Ontario. CHU broadcasts continuously on 3.330, 7.850, and 14.670 MHz.

Shortwave time signals travel near the speed of light. However, there is a tangible delay between the time they are transmitted and received at your location. This delay increases with your distance from the station. To complicate things further, the amount of the delay for a given location can vary.

If you are several thousand miles from a shortwave time station, the amount of the delay and its variability can make the signals useless for critical timing applications. For most users in the U.S. the received accuracy of time signals from WWV and WWVH should be better than 1/100 of a second.

WWV and WWVH are usually audible up to 2,000 miles away using relatively simple equipment. CHU provides a comparable quality signal in the northeastern U.S. and eastern Canada. Portable shortwave receivers from Sangean, Sony, and other manufacturers offer the least expensive means to hear these stations.

The webmaster purchased this Sangean receiver on sale for about $120. Despite its low cost, it is more than adequate for hearing shortwave time signals in the continental U.S. Copyright 2006, Brian Webb

Unless you are located relatively close to a shortwave time station, you may need to use an external antenna. You can make a simple, but effective external antenna from a length of insulated wire that is 20 feet or longer. Strip the insulation off one end of the wire and connect it to the radio. Depending on the radio, the connection is made by clipping or wrapping the end of the antenna around the tip of the whip antenna, securing it using an antenna terminal screw, or inserting it into an antenna jack using the appropriate plug.

An antenna for receiving shortwave time signals can be fashioned from a length of insulated wire. Speaker wire sold at Radio Shack is inexpensive and works well. The alligator clip attaches the wire to the tip of the radio's antenna. Copyright 2006, Brian Webb

At locations several hundred miles or more from the nearest shortwave time station, reception occurs by way of the ionosphere. The ionosphere, and the thus the reception quality for a given frequency, are affected by the time of day, current solar activity, and season.

The best way to deal with changing ionospheric conditions is to check several time station frequencies to find the one with the best signal. If your receiver has programmable memories, use them to store several time station frequencies (in North America these would be 2.500, 3.330, 5.000, 7.850, 10.000, 14.670, 15.000, and 20.000 MHz).

One problem that can hamper shortwave time signal reception is natural or manmade radio noise. The primary source of natural noise is lightning from thunderstorms. Such noise tends to increase as the frequency decreases. You may be able to minimize it by avoiding frequencies below 8 MHz.

14 Utc Time

Electronic and electrical equipment such as computers, TV sets, and fluorescent lights can generate signals over a wide range of frequencies. Power lines, cable television cabling, and house wiring are other potential sources of radio interference.

There are several ways to counter manmade interference. First, turn off unneeded electronic or electrical equipment. You can also physically separate your receiver and antenna from potential interference sources. Amazon photo storage pricing. An effective way to mitigate the manmade interference common within buildings is to use an appropriately placed outdoor antenna.

Telephone

You can also obtain the current UTC by telephone. NIST provides the audio from WWV at (303) 499-7111 and WWVH at (808) 335-4363. Time signals and voice announcements of the current UTC are also available from the U.S. Naval Observatory at (202) 762-1069 and (202) 762-1401. You can only connect to these numbers for a brief time before the call is terminated. Note that these are not toll-free numbers and callers outside the local calling area are charged at regular long-distance rates.

The accuracy of time signals received by telephone varies with your distance from the time source and the type of connection. According to NIST, their telephone time announcements are normally delayed by less than 3/100 of a second when using land lines from within the continental United States and the delay variation is generally less than 1/1000 of a second. When using mobile phones, the delays are often more than 1/10 of a second due to the multiple access methods used to share cell channels. In rare instances when the telephone connection is via satellite, the time is delayed by 1/4 to 1/2 of a second.

GPS

An overlooked source of UTC is the Global Positioning System. GPS offers reliable, worldwide coverage and the potential for extremely accurate timing.

Some GPS receivers have a setup option to display the current UTC. Other units can be configured to display the current UTC by specifying a custom time zone with a UTC offset of 0 hours 00 minutes and disabling the automatic Daylight Saving Time correction.

The webmaster's vintage Magellan GPS 2000 searches for satellites to update its position and internal clock. This unit provides a set up option to display the current time as UT. Copyright 2006, Brian Webb

Most GPS receivers only use what is known as the 'NMEA sentence' for timing and can have delays of several tenths of a second. There are also reports of GPS receivers experiencing intermittent errors in the displayed time amounting to entire seconds.

When you use a GPS receiver to receive the current UTC, be sure to let it obtain a good lock so it can update its clock. Otherwise, the displayed time may be incorrect. For applications requiring accuracy within a second or so, you should verify the accuracy of your GPS' displayed UTC by comparing it against an accurate time standard.

Reliable, precision timing is available from the Global Positioning System, but this requires a receiver that uses the GPS 1PPS signal. Such units provide the current UTC to an accuracy of 1/1000 of a second or better.

14 Utc Time14 Utc Time

Notes

1In the U.S. and Canada, Standard Time (PST, MST, CST, and EST) is in effect from the last Sunday in October to the first Sunday in April. Daylight Saving Time (PDT, MDT, CDT, and EDT) is in effect from the first Sunday in April to the last Sunday in October.

2The following is a table of all time stations reported to be in operation. The information was obtained from various sources, most notably the 2006 World Radio and TV Handbook.

Frequency
(MHz)
CallsignLocationComments
0.0205RAB99Khabarovsk, Russia02:06-02:47 and 06:06-06:47 UTC, 01:06-01:47 and 05:06-05:47 UTC summer
0.0205RJH69Maladziecna, Belarus07:06-07:47 UTC, 06:06-06:47 UTC summer
0.0205RJH77Arkhangelsk, Russia09:06-09:47 UTC, 08:06-08:47 UTC summer
0.0205RJH99N. Novgorod, Russia05:06-05:47 UTC, 04:06-04:47 UTC summer
0.0230RAB99Khabarovsk, Russia02:06-02:47 and 06:06-06:47 UTC, 01:06-01:47 and 05:06-05:47 UTC summer
0.0230RJH69Maladziecna, Belarus07:06-07:47 UTC, 06:06-06:47 UTC summer
0.0230RJH77Arkhangelsk, Russia09:06-09:47 UTC, 08:06-08:47 UTC summer
0.0230RJH99N. Novgorod, Russia05:06-05:47 UTC, 04:06-04:47 UTC summer
0.0250RAB99Khabarovsk, Russia02:06-02:47 and 06:06-06:47 UTC, 01:06-01:47 and 05:06-05:47 UTC summer
0.0250RJH66Bishkek, Kyrgyzstan04:06-04:47, 10:06-10:47 UTC
0.0250RJH69Maladziecna, Belarus07:06-07:47 UTC, 06:06-06:47 UTC summer
0.0250RJH77Arkhangelsk, Russia09:06-09:47 UTC, 08:06-08:47 UTC summer
0.0250RJH99N. Novgorod, Russia05:06-05:47 UTC, 04:06-04:47 UTC summer
0.0251RAB99Khabarovsk, Russia02:06-02:47 and 06:06-06:47 UTC, 01:06-01:47 and 05:06-05:47 UTC summer
0.0251RJH69Maladziecna, Belarus07:06-07:47 UTC, 06:06-06:47 UTC summer
0.0251RJH77Arkhangelsk, Russia09:06-09:47 UTC, 08:06-08:47 UTC summer
0.0251RJH99N. Novgorod, Russia05:06-05:47 UTC, 04:06-04:47 UTC summer
0.0255RAB99Khabarovsk, Russia02:06-02:47 and 06:06-06:47 UTC, 01:06-01:47 and 05:06-05:47 UTC summer
0.0255RJH69Maladziecna, Belarus07:06-07:47 UTC, 06:06-06:47 UTC summer
0.0255RJH77Arkhangelsk, Russia09:06-09:47 UTC, 08:06-08:47 UTC summer
0.0255RJH99N. Novgorod, Russia05:06-05:47 UTC, 04:06-04:47 UTC summer
0.0400JJYOhtakadoyayama, JapanContinuous
0.0600JJYHaganeyama, JapanContinuous
0.0600MSFRugby, UKContinuous
0.0600WWVBFort Collins, Colorado, USAContinuous
0.0666RBUMoscow, RussiaContinuous
0.0750HBGPrangins, SwitzerlandContinuous
0.0775DCF77Mainflingen, GermanyContinuous
0.1620---Allouis, FranceContinuous
1.5100HD2IOAGuayaquil, EcuadorContinuous
2.5000BPMLinshan, China09:00-01:00 UTC
2.5000WWVFort Collins, Colorado, USAContinuous
2.5000WWVHKekaha, Hawaii, USAContinuous
3.3300CHUOttawa, CanadaContinuous
3.8100HD2IOAGuayaquil, Ecuador19:00-07:00 UTC
4.9960RWMMoscow, RussiaContinuous
4.9980EBCCadiz, Spain10:00-11:00 UTC Monday-Friday
5.0000BPMLinshan, ChinaContinuous
5.0000BSFChungli, TaiwanContinuous
5.0000HD2IOAGuayaquil, Ecuador12:00-13:00 UTC
5.0000HLADaejeon, South KoreaContinuous
5.0000LOLBuenos Aires, Argentina11:00-12:00, 14:00-15:00, 17:00-18:00, 20:00-21:00, 23:00-24:00 UTC
5.0000WWVFort Collins, Colorado, USAContinuous
5.0000WWVHKekaha, Hawaii, USAContinuous
5.0000YVTOCaracas, VenezuelaContinuous
7.8500CHUOttawa, CanadaContinuous
7.6000HD2IOAGuayaqil, Ecuador13:00-24:00 UTC
9.9960RWMMoscow, RussiaContinuous
10.0000BPMLinshan, ChinaContinuous
10.0000LOLBuenos Aires, Argentina11:00-12:00, 14:00-15:00, 17:00-18:00, 20:00-21:00, 23:00-24:00 UTC
10.0000WWVFort Collins, Colorado, USAContinuous
10.0000WWVHKekaha, Hawaii, USAContinuous
14.6700CHUOttawa, CanadaContinuous
14.9960RWMMoscow, RussiaContinuous
15.0000BPMLinshan, China01:00-09:00 UTC
15.0000BSFChungli, TaiwanContinuous
15.0000WWVFort Collins, Colorado, USAContinuous
15.0000WWVHKekaha, Hawaii, USAContinuous
15.0060EBCCadiz, Spain10:00-11:00 UTC Monday-Friday
20.0000WWVFort Collins, Colorado, USAContinuous

Abbreviations

Utc +14 Time Zone

CDTCentral Daylight Time
CSTCentral Standard Time
EDTEastern Daylight Time
ESTEastern Standard Time
MDTMountain Daylight Time
MSTMountain Standard Time
NMEANational Marine Electronics Association
PDTPacific Daylight Time
PSTPacific Standard Time
UTCCoordinated Universal Time

Home Site Map Search About Contact

Copyright © 2003-2018, Brian Webb. All rights reserved.

The current Unix epoch time is

Convert epoch to human-readable date and vice versa



Utc+14 time right now

12:14 Utc Time

Also see our dynamic list of dates (1 day ago, next week, etc.)
Press c to clear all forms.

Epoch dates for the start and end of the year/month/day


Convert seconds to days, hours and minutes

What is epoch time?

The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z).Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch' is often used as a synonym for Unix time.Some systems store epoch dates as a signed 32-bit integer, which might cause problems on January 19, 2038 (known as the Year 2038 problem or Y2038).The converter on this page converts timestamps in seconds (10-digit), milliseconds (13-digit) and microseconds (16-digit) to readable dates.

Human-readable time Seconds
1 hour3600 seconds
1 day86400 seconds
1 week604800 seconds
1 month (30.44 days) 2629743 seconds
1 year (365.24 days) 31556926 seconds

14 Utc Time In Est Time

How to get the current epoch time in ..

PHPtime()More PHP
Pythonimport time; time.time()Source
RubyTime.now (or Time.new). To display the epoch: Time.now.to_i
PerltimeMore Perl
Javalong epoch = System.currentTimeMillis()/1000; Returns epoch in seconds.
C#DateTimeOffset.Now.ToUnixTimeSeconds() (.NET Framework 4.6+/.NET Core), older versions: var epoch = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)).TotalSeconds;
Objective-C[[NSDate date] timeIntervalSince1970]; (returns double) or NSString *currentTimestamp = [NSString stringWithFormat:@'%f', [[NSDate date] timeIntervalSince1970]];
C++11double now = std::chrono::duration_cast<std::chrono::seconds>(std::chrono::system_clock::now().time_since_epoch()).count();
Luaepoch = os.time([date])
VBScript/ASPSee the examples
AutoIT_DateDiff('s', '1970/01/01 00:00:00', _NowCalc())
DelphiEpoch := DateTimetoUnix(Now); Tested in Delphi 2010.
Ras.numeric(Sys.time())
Erlang/OTPerlang:system_time(seconds). (version 18+), older versions: calendar:datetime_to_gregorian_seconds(calendar:universal_time())-719528*24*3600.
MySQLSELECT unix_timestamp(now())More MySQL examples
PostgreSQLSELECT extract(epoch FROM now());
SQLiteSELECT strftime('%s', 'now');
Oracle PL/SQLSELECT (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - TO_DATE('01/01/1970','DD/MM/YYYY')) * 24 * 60 * 60 FROM DUAL;
SQL ServerSELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
IBM InformixSELECT dbinfo('utc_current') FROM sysmaster:sysdual;
JavaScriptMath.floor(new Date().getTime()/1000.0) The getTime method returns the time in milliseconds.
Visual FoxProDATETIME() - {^1970/01/01 00:00:00} Warning: time zones not handled correctly
Gotime.Now().Unix()More Go
Adobe ColdFusion<cfset epochTime = left(getTickcount(), 10)>
Tcl/Tkclock seconds
Unix/Linux Shelldate +%s
Solaris/usr/bin/nawk 'BEGIN {print srand()}' Solaris doesn't support date +%s, but the default seed value for nawk's random-number generator is the number of seconds since the epoch.
PowerShell[int][double]::Parse((Get-Date (get-date).touniversaltime() -UFormat %s))
Other OS's Command line: perl -e 'print time' (If Perl is installed on your system)

Convert from human-readable date to epoch

PHPstrtotime('15 November 2018') (converts most English date texts) or:
date_create('11/15/2018')->format('U') (using DateTime class) More PHP
Pythonimport calendar, time; calendar.timegm(time.strptime('2000-01-01 12:34:00', '%Y-%m-%d %H:%M:%S'))
RubyTime.local(year, month, day, hour, minute, second, usec ) (or Time.gm for GMT/UTC input). To display add .to_i
PerlUse the Perl Epoch routines
Javalong epoch = new java.text.SimpleDateFormat('MM/dd/yyyy HH:mm:ss').parse('01/01/1970 01:00:00').getTime() / 1000; Timestamp in seconds, remove '/1000' for milliseconds.
VBScript/ASPDateDiff('s', '01/01/1970 00:00:00', time field)More ASP
AutoIT_DateDiff('s', '1970/01/01 00:00:00', 'YYYY/MM/DD HH:MM:SS')
DelphiEpoch := DateTimeToUnix(StrToDateTime(myString));
CUse the C Epoch Converter routines
Ras.numeric(as.POSIXct('YYYY-MM-dd HH:mm:ss', tz = 'GMT', origin='1970-01-01')) The origin parameter is optional
GoExample code
RustSystemTime::now().duration_since(SystemTime::UNIX_EPOCH)
Adobe ColdFusionint(parseDateTime(datetime).getTime()/1000);
MySQLSELECT unix_timestamp(time) Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
More on using Epoch timestamps with MySQL
PostgreSQLSELECT extract(epoch FROM date('2000-01-01 12:34'));
With timestamp: SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2018-02-16 20:38:40-08');
With interval: SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
SQLiteSELECT strftime('%s',timestring);
SQL ServerSELECT DATEDIFF(s, '1970-01-01 00:00:00', time field)
JavaScriptUse the JavaScript Date object
Unix/Linux Shelldate +%s -d'Jan 1, 1980 00:00:01' Replace '-d' with '-ud' to input in GMT/UTC time.

Convert from epoch to human-readable date

PHPdate(output format, epoch); Output format example: 'r' = RFC 2822 date, more PHP examples
Pythonimport time; time.strftime('%a, %d %b %Y %H:%M:%S +0000', time.localtime(epoch))Replace time.localtime with time.gmtime for GMT time. Or using datetime:import datetime; datetime.datetime.utcfromtimestamp(epoch).replace(tzinfo=datetime.timezone.utc)
RubyTime.at(epoch)
C#private string epoch2string(int epoch) {
return new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(epoch).ToShortDateString(); }
PerlUse the Perl Epoch routines
JavaString date = new java.text.SimpleDateFormat('MM/dd/yyyy HH:mm:ss').format(new java.util.Date (epoch*1000)); Epoch in seconds, remove '*1000' for milliseconds.
Luadatestring = os.date([format[,epoch]])
VBScript/ASPDateAdd('s', epoch, '01/01/1970 00:00:00')More ASP
AutoIT_DateAdd('s', $EpochSeconds , '1970/01/01 00:00:00')
DelphimyString := DateTimeToStr(UnixToDateTime(Epoch)); Where Epoch is a signed integer.
CUse the C Epoch Converter routines
Objective-CNSDate * myDate = [NSDate dateWithTimeIntervalSince1970:epoch]; NSLog(@'%@', date);
Ras.POSIXct(epoch, origin='1970-01-01', tz='GMT')
GoExample code
Adobe ColdFusionDateAdd('s',epoch,'1/1/1970');
MySQLFROM_UNIXTIME(epoch, optional output format) Default output format is YYY-MM-DD HH:MM:SS. If you need support for negative timestamps: DATE_FORMAT(DATE_ADD(FROM_UNIXTIME(0), interval -315619200 second),'%Y-%m-%d') (replace -315619200 with epoch) More MySQL
PostgreSQLPostgreSQL version 8.1 and higher: SELECT to_timestamp(epoch);Source Older versions: SELECT TIMESTAMP WITH TIME ZONE 'epoch' + epoch * INTERVAL '1 second';
SQLiteSELECT datetime(epoch_to_convert, 'unixepoch'); or local timezone: SELECT datetime(epoch_to_convert, 'unixepoch', 'localtime');
Oracle PL/SQLSELECT to_date('01-JAN-1970','dd-mon-yyyy')+(1526357743/60/60/24) from dual
Replace 1526357743 with epoch.
SQL ServerDATEADD(s, epoch, '1970-01-01 00:00:00')
IBM InformixSELECT dbinfo('utc_to_datetime',epoch) FROM sysmaster:sysdual;
Microsoft Excel / LibreOffice Calc=(A1 / 86400) + 25569 Format the result cell for date/time, the result will be in GMT time (A1 is the cell with the epoch number). For other time zones: =((A1 +/- time zone adjustment) / 86400) + 25569.
Crystal ReportsDateAdd('s', {EpochTimeStampField}-14400, #1/1/1970 00:00:00#) -14400 used for Eastern Standard Time. See Time Zones.
JavaScriptUse the JavaScript Date object
Tcl/Tkclock format 1325376000Documentation
MATLABdatestr(719529+TimeInSeconds/86400,'dd-mmm-yyyy HH:MM:SS')
IBM PureData System for Analyticsselect 996673954::int4::abstime::timestamp;
Unix/Linux Shelldate -d @1520000000 Replace 1520000000 with your epoch, needs recent version of 'date'. Replace '-d' with '-ud' for GMT/UTC time.
Mac OS Xdate -j -r 1520000000
PowerShellFunction get-epochDate ($epochDate){ [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds($epochDate)) }, then use: get-epochDate 1520000000. Works for Windows PowerShell v1 and v2
Other OS'sCommand line: perl -e 'print scalar(localtime(epoch))' (If Perl is installed) Replace 'localtime' with 'gmtime' for GMT/UTC time.


Thanks to everyone who sent me corrections and updates!

More date related programming examples: What's the current week number? - What's the current day number?

Please note: All tools on this page are based on the date & time settings of your computer and use JavaScript to convert times. Some browsers use the current DST (Daylight Saving Time) rules for all dates in history. JavaScript does not support leap seconds.