Get Unix timestamp in Java, Python, Erlang, JavaScript, Go, MySQL

Mostly a note for myself. To Get Unix timestamp value in seconds

Java:

long timestamp = System.currentTimeMillis()/1000

Python:

import time
timestamp = int(time.time())

Erlang:

{Mega, Secs, _} = now(),
Timestamp = Mega*1000000 + Secs,

JavaScript:

var ts = Math.floor(Date.now()/1000); // You can also use new Date().getTime()/1000 but this one is faster

Go:

package main
import (
"time"
"fmt"
)

func main() {
// Get and print integer timestamp
timestamp := time.Now().Unix()
fmt.Printf(“unixtime: %d\n”, timestamp)
// get and print floating point timestamp with sub-second precision
timestampFloat := float64(time.Now().UnixNano()) / 1.0e9
fmt.Printf(“unixtime: %f\n”, timestampFloat)

//Convert integer timestamp back to Time:
t1 := time.Unix(timestamp, 0)
fmt.Printf(“Time: %v\n”, t1)

//Convert floating point timestamp back to Time
t2 := time.Unix(int64(timestampFloat), int64((timestampFloat – float64(int64(timestampFloat)))*1e9))
fmt.Printf(“Time: %v\n”, t2)
}

Working with timestamps in MySQL

mysql> SELECT UNIX_TIMESTAMP('1997-10-04 22:23:00');
-> 875996580
mysql> SELECT FROM_UNIXTIME(1111885200);
+---------------------------+
| FROM_UNIXTIME(1111885200) |
+---------------------------+
| 2005-03-27 03:00:00 |
+---------------------------+


About these ads