Date & Time

MICROSECOND

MySQL

Mengembalikan komponen microsecond (0-999999) dari time atau datetime expression.

Tipe hasil: INT

Syntax

SQL

MICROSECOND(expr)

Parameter

exprTIME/DATETIMEwajib

Waktu atau datetime yang akan diekstrak

Contoh Penggunaan

Get Microseconds

SQL

1 SELECT MICROSECOND('12:30:45.123456') AS microsec;

Ekstrak microsecond dari waktu.

Hasil

microsec: 123456

High Precision Timing

SQL

1 SELECT event_id,
2        event_time,
3        MICROSECOND(event_time) AS microsec
4 FROM high_freq_events;

Analisis timing dengan presisi tinggi.

Hasil

(events with microsecond precision)

Calculate Sub-second Diff

SQL

1 SELECT start_time, end_time,
2        (UNIX_TIMESTAMP(end_time) - UNIX_TIMESTAMP(start_time)) +
3        (MICROSECOND(end_time) - MICROSECOND(start_time)) / 1000000 AS duration_sec
4 FROM transactions;

Durasi dengan presisi microsecond.

Hasil

(precise durations)

Kembali ke MySQL Functions

1	SELECT event_id,
2	event_time,
3	MICROSECOND(event_time) AS microsec
4	FROM high_freq_events;

1	SELECT start_time, end_time,
2	(UNIX_TIMESTAMP(end_time) - UNIX_TIMESTAMP(start_time)) +
3	(MICROSECOND(end_time) - MICROSECOND(start_time)) / 1000000 AS duration_sec
4	FROM transactions;