Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no guarantee. MySQL ...A value of 0 signifies that there is no fractional ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-conversion.html
For example, although DATE, DATETIME, and TIMESTAMP values all can be specified using the same set of formats, the types do not all have the same range of values. This means that a date such as '1968-01-01', while valid as a DATE or DATETIME value, ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
AllowZeroDateTime , Allow Zero Datetime Default: false If set to True, MySqlDataReader.GetValue() returns a MySqlDateTime object for date or datetime columns that have disallowed values, such as zero datetime values, and a System.DateTime object for ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
AllowZeroDateTime , Allow Zero Datetime Default: false If set to True, MySqlDataReader.GetValue() returns a MySqlDateTime object for date or datetime columns that have disallowed values, such as zero datetime values, and a System.DateTime object for ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
You can set DATE, TIME, DATETIME, and TIMESTAMP as optional column-level parameters. You can also set datetime formats for each column by using the EXTERNAL_FORMAT statement, which overrides the format in the table parameter. The following example ... As of MySQL 9.4.0, you can set external table options using SQL ...
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
Starting from MySQL 8.0.19, you can also specify a time zone offset when storing TIMESTAMP values (see The DATE, DATETIME, and TIMESTAMP Types for details), in which case the TIMESTAMP values are converted to the UTC from the specified offset ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
BYTES x x x GEOMETRY BYTES TIME TIME x DATE DATETIME x DATETIME DATETIME x YEAR UINT x x TIMESTAMP DATETIME x SET SET x ENUM ENUM x NULL BYTES BIT BIT x Note The SQL "NULL" value is sent as an empty field value in Row. Example: 0x00 -> ... Topics in ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
-- Attributes -- c1 Datetime NULL AT=FIXED ST=MEMORY c2 Date NULL AT=FIXED ST=MEMORY c3 Time NULL AT=FIXED ST=MEMORY c4 Timestamp NOT NULL AT=FIXED ST=MEMORY DEFAULT 0 c5 Year NULL AT=FIXED ST=MEMORY The affected MySQL types are TIME, DATETIME, and ... This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
Starting from MySQL 8.0.19, you can also specify a time zone offset when storing TIMESTAMP values (see The DATE, DATETIME, and TIMESTAMP Types for details), in which case the TIMESTAMP values are converted to the UTC from the specified offset ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
CAST(expr AS type [ARRAY]) CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)]) timezone_specifier: [INTERVAL] '+00:00' | 'UTC' With CAST(expr AS type syntax, the CAST() function takes an expression of any type and produces ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...