Hello, I put this in the Corral as it is not really a question...
I was concatenating to create a unique ID by adding a DATETIME value to a given CHAR value. This went well. I then wanted to add some archive data which used DATE and TIME. Well I was surprised when during a test the values were okay even though I thought I would need more conversions/manipulations.
CREATE TABLE #myTemp (RecDate DATE, RecTime TIME); INSERT INTO #myTemp VALUES ('2012-05-04','10:11:20.0000000'), ('2012-05-04','08:19:09.0000000'), ('2012-05-04','11:09:29.0000000'); -- style 120 --- yyyy-mm-dd hh:mi:ss(24h) SELECT P.RecDate, CONVERT(VARCHAR(20), P.RecDate, 120), P.RecTime, CONVERT(VARCHAR(20), P.RecTime, 120), CONVERT(VARCHAR(20), P.RecDate, 120) + ' ' + CONVERT(VARCHAR(20), P.RecTime, 120) FROM #myTemp P; DROP TABLE #myTemp;
I though the time would add a date and the date add a time. Note I used code from converting the DATETIME and had not changed it yet. At this point I found I did not need to make changes to the code.
Just thought I would see if anyone else had similar "it was less complicated than I thought".