Cmdlets for MySQL

Build 24.0.9175

ZeroDatesToNull Parameter (Connect-MySQL Cmdlet)

Whether or not to return Date and DateTime values consisting of all zeros as NULL.

Syntax

Connect-MySQL -ZeroDatesToNull bool

Data Type

bool

Default Value

true

Remarks

Whether or not to return Date and DateTime values consisting of all zeros as NULL. A value of all zeros indicates an invalid Date or DateTime value in MySQL. Retrieving such a value may cause parsing errors unless you set this property to True.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175