DATETIMEV2

Description

DATETIMEV2([P])

The optional parameter P indicates the time accuracy. The range of P is [0, 6], that is, it supports 6 decimal places (microseconds) at most. P will be set to 0 by default.

The range of DATETIME type is ['0000-01-01 00:00:00[.000000]','9999-12-31 23:59:59[.999999]']. It will be printed as 'YYYY-MM-DD HH:MM:SS.ffffff'

Note

DATETIMEV2 is more efficient than DATETIME and supports time accuracy down to microseconds.

Keywords

DATETIMEV2

DATETIME DATEV2