Forums

Administration & IT joining date and time

joining date and time

Richard Laslett $organization over 16 years ago

I have a several hundred thousand records

in a table where the date and time are seperate

values

that I need

to join into one datetime value

where

(perf_dt) = 2004-12-20 00:00:

00.000

and

perf_time = 1899-12-30 18:30:

00.000

result that

is desired is 2004-12-20 18:30:

00.000

I would appreciate a tip

from some

one how to code this

Parents

Ben Magson $organization over 16 years ago

Hi Richard

I guess you are saying you have a perf_dt column and perf_time column in the same table?

If so, give this statement a whirl...

select convert(datetime,convert(varchar,perf_dt,101) + ' ' + convert(varchar,perf_time,108),111) from your_table

Thanks, Ben
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Ben Magson $organization over 16 years ago

Hi Richard

I guess you are saying you have a perf_dt column and perf_time column in the same table?

If so, give this statement a whirl...

select convert(datetime,convert(varchar,perf_dt,101) + ' ' + convert(varchar,perf_time,108),111) from your_table

Thanks, Ben
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data