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

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions