I was tasked to create a system from an existing system. The old system database table is shown below:
How can I query the above example to something like this?Code:Date Time ID 5/4/2009 00:00:00 1899/12/30 07:55:30 84321
I try to do this using this query:Code:DateTime ID 5/4/2009 07:55:30 84321
But unfortunately the result is this:Code:select Date + Time as 'DateTimeRecord', ID from transdata
Code:DateTime ID 5/2/2009 07:55:30 84321