mz_timestamp type
mz_timestamp data expresses an internal timestamp.
mz_timestamp info
| Detail | Info |
|---|---|
| Size | 8 bytes |
| Catalog name | mz_catalog.mz_timestamp |
| OID | 16552 |
| Min value | 0 |
| Max value | 18446744073709551615 |
Details
- This type is produced by
mz_now(). - In general this is an opaque type, designed to ease the use of
mz_now()by making various timestamp types castable to it.
Valid casts
For details about casting, including contexts, see Functions: Cast.
Integer, numeric, and text casts must be in the form of milliseconds since the Unix epoch.
| From | To | Required context |
|---|---|---|
mz_timestamp |
text |
Assignment |
text |
mz_timestamp |
Assignment |
uint4 |
mz_timestamp |
Implicit |
uint8 |
mz_timestamp |
Implicit |
int4 |
mz_timestamp |
Implicit |
int8 |
mz_timestamp |
Implicit |
numeric |
mz_timestamp |
Implicit |
timestamp |
mz_timestamp |
Implicit |
timestamptz |
mz_timestamp |
Implicit |
Valid operations
There are no supported operations or functions on mz_timestamp types.