Results 1 to 3 of 3

Thread: Combination of Date and Time Column in SQL

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2007
    Posts
    240

    Combination of Date and Time Column in SQL

    I was tasked to create a system from an existing system. The old system database table is shown below:


    Code:
    Date                                Time                              ID
    5/4/2009 00:00:00           1899/12/30 07:55:30         84321
    How can I query the above example to something like this?

    Code:
    DateTime                               ID
    5/4/2009 07:55:30                 84321
    I try to do this using this query:

    Code:
    select Date + Time as 'DateTimeRecord', ID from transdata
    But unfortunately the result is this:

    Code:
    DateTime                               ID
    5/2/2009 07:55:30                 84321
    Last edited by jsc0624; Jun 22nd, 2009 at 03:29 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width