Hello
When I use CONVERT(varchar,[Date1]), the date '1900-01-01 00:00:00.000' becomes 'Jan 1 1900 12:00AM'
It is not what I was expecting really, as I was expecting the string '1900-01-01 00:00:00.000' which can then be unioned to a column containing text.
How can I convert columns into strings in a literal way?
Thanks!