You need to convert to char first because converting to int adds those days to 1900-01-01

Here are some examples

1900-01-06 00:00:00.000

does not work, because you can’t add 20100101 days to 1900-01-01 You go above the limit

Convert to char first

or

Share This Via: