Unix Timestamp Code Examples by Programming Language

time()

import time; time.time()

Time.now (or Time.new). To display the epoch: Time.now.to_i

time

long epoch = System.currentTimeMillis()/1000;

DateTimeOffset.Now.ToUnixTimeSeconds()

[[NSDate date] timeIntervalSince1970];

double now = std::chrono::duration_cast<std::chrono::seconds> (std::chrono::system_clock::now().time_since_epoch()).count();

epoch = os.time([date])

See the examples

_DateDiff('s', "1970/01/01 00:00:00", _NowCalc())

Epoch := DateTimetoUnix(Now);

DateTime.now().microsecondsSinceEpoch

as.numeric(Sys.time())

erlang:system_time(seconds).

SELECT unix_timestamp(now())

SELECT extract(epoch FROM now());

SELECT strftime('%s', 'now');

SELECT (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - TO_DATE('01/01/1970','DD/MM/YYYY')) * 24 * 60 * 60 FROM DUAL;

SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())

SELECT dbinfo('utc_current') FROM sysmaster:sysdual;

Math.floor(new Date().getTime()/1000.0)

DATETIME() - {^1970/01/01 00:00:00}

time.Now().Unix()

<cfset epochTime = left(getTickcount(), 10)>

clock seconds

date +%s

/usr/bin/nawk 'BEGIN {print srand()}'

[int][double]::Parse((Get-Date (get-date).touniversaltime() -UFormat %s))

perl -e "print time"

strtotime("15 November 2018")

import calendar, time; calendar.timegm(time.strptime('2000-01-01 12:34:00', '%Y-%m-%d %H:%M:%S'))

Time.local(year, month, day, hour, minute, second, usec )

Use the Perl Epoch routines

long epoch = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").parse("01/01/1970 01:00:00").getTime() / 1000;

DateDiff("s", "01/01/1970 00:00:00", time field)

_DateDiff('s', "1970/01/01 00:00:00", "YYYY/MM/DD HH:MM:SS")

Epoch := DateTimeToUnix(StrToDateTime(myString));

Use the C Epoch Converter routines

as.numeric(as.POSIXct("YYYY-MM-dd HH:mm:ss", tz = "GMT", origin="1970-01-01"))

Example code

SystemTime::now().duration_since(SystemTime::UNIX_EPOCH)

int(parseDateTime(datetime).getTime()/1000);

SELECT unix_timestamp(time)

SELECT extract(epoch FROM date('2000-01-01 12:34'));

SELECT strftime('%s',timestring);

SELECT DATEDIFF(s, '1970-01-01 00:00:00', time field)

Use the JavaScript Date object

date +%s -d"Jan 1, 1980 00:00:01"

date(output format, epoch);

import time; time.strftime("%a, %d %b %Y %H:%M:%S +0000", time.localtime(epoch))

Time.at(epoch)

private string epoch2string(int epoch) {
  return new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(epoch).ToShortDateString();
}

Use the Perl Epoch routines

String date = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").format(new java.util.Date (epoch*1000));

datestring = os.date([format[,epoch]])

DateAdd("s", epoch, "01/01/1970 00:00:00")

_DateAdd("s", $EpochSeconds , "1970/01/01 00:00:00")

DateTime.fromMicrosecondsSinceEpoch(epoch)

myString := DateTimeToStr(UnixToDateTime(Epoch));

Use the C Epoch Converter routines

NSDate * myDate = [NSDate dateWithTimeIntervalSince1970:epoch]; NSLog(@"%@", date);

as.POSIXct(epoch, origin="1970-01-01", tz="GMT")

Example code

DateAdd("s",epoch,"1/1/1970");

FROM_UNIXTIME(epoch, optional output format)

SELECT to_timestamp(epoch);

SELECT datetime(epoch_to_convert, 'unixepoch');

SELECT to_date('01-JAN-1970','dd-mon-yyyy')+(1526357743/60/60/24) from dual

DATEADD(s, epoch, '1970-01-01 00:00:00')

SELECT dbinfo('utc_to_datetime',epoch) FROM sysmaster:sysdual;

=(A1 / 86400) + 25569

DateAdd("s", {EpochTimeStampField}-14400, #1/1/1970 00:00:00#)

Use the JavaScript Date object

clock format 1325376000

datestr(719529+TimeInSeconds/86400,'dd-mmm-yyyy HH:MM:SS')

select 996673954::int4::abstime::timestamp;

date -d @1520000000

date -j -r 1520000000

Function get-epochDate ($epochDate) { [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds($epochDate)) }, then use: get-epochDate 1520000000.

perl -e "print scalar(localtime(epoch))"