I had this command;
"CONVERT(VARCHAR,issdate,112) issdate, "
I thought this was converting the date (in date format) to character type yyyymmdd, but I just noticed the date format is back again.
Is the above right command to convert date to yyyymmdd? I am using vb.net with sql server 2003