var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Concantenating Dates
I am transferring data between DB's. One has DATE and TIME as two individual fields. I need to concantenate them into a single DATETIME field. I am sure the solution is simple but I can't figure it out.
If you select from your time column, you should see that it's date is set to January 1st, 1900, like this:
Your date column should show a date as of midnight like this:
If this is the case, you can just add these value together to concatenate them:
select @Yourdate + @Yourtime
If this is not the case, you will need to concatenate them as formatted strings and then cast or convert the result to a datetime value.