SELECT TRY_CONVERT(date, 'a')
-- returns NULL
SELECT TRY_CONVERT(date, '')
- returns 1900-01-01
SELECT TRY_CONVERT(date, ' ')
- returns 1900-01-01
What's so special about an empty string or a whitespace?
#SQLServer
@Ko_Ver That is indeed interesting, hehe. And maybe slightly counter-intuitive.
I guess the note to take from this is that we should always be very mindful when dealing with empty strings.
@Ko_Ver At least an interesting tidbit :)
I was reading TRY_CONVERT at SQL Docs (https://t.co/cxKd77Gh7r) and was sure it could be used the way I wanted it to.
But yes, I should have known, should've known.
It's not too late to register for @SQLSatOslo with @BuckWoodyMSFT & industry experts for a free, full day of training.
📅 August 29
Register today: https://t.co/6aoolbGsvR
#sqlsatoslo#sqlfamily#sqlsaturday
Check out the first ever New Stars of Data event this Friday.
This is an event to help find and promote new speakers in the Microsoft Data Platform arena.
Schedule: https://t.co/pbzqYg1d2u
Registration: https://t.co/JXvMa3esGM
Denne notisen fra @nrknyheter er det eneste jeg har sett i store norske medier i dag om stortingsbehandling av ny lov om Etteretningstjenesten, som i dag ble vedtatt. Dette medfører "masseovervåkning av norske borgere" (sitat @Datatilsynet). Hvor er resten av medie-Norge?