Tag: Oracle date conversion

Day and Month strings contain trailing spaces

When you convert an Oracle Date into a characters string representing the Day or the Month the text strings aren’t quite what you would expect. On a couple of occasions I have written a SQL statement like the following and been left scratching my head

Why hasn’t it returned¬†any Saturdays? The character string that Read More