Skip to content

CAST('0', 'DateTime') fails but '00000' works #64708

@tanner-bruce

Description

@tanner-bruce

https://fiddle.clickhouse.com/16f87a7e-0ff0-4b50-ace8-2c8087567b01

and it must specifically be 5 or more 0's in the string

SELECT CAST('00000', 'DateTime'); -- works
SELECT CAST('0', 'DateTime'); -- fails

Metadata

Metadata

Labels

invalidunexpected behaviourResult is unexpected, but not entirely wrong at the same time.

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions