Link to home
Start Free TrialLog in
Avatar of srodgers45
srodgers45

asked on

converting date and time into datetime in SQL view

I am creating a view in SQL and have a date and time field that are separate as a string and want to make them a single datetime value.

Current Format

Separate columns in table:

Date:
1912-11-26    

Time:
10:20:00

desired format in new column:
2012-12-13 13:12:00

Thanks for any assistance
Avatar of Sharath S
Sharath S
Flag of United States of America image

How do you convert 1912-11-26 to 2012-12-13?
and 10:20:00 to 13:12:00?
Avatar of srodgers45
srodgers45

ASKER

That was just an example of the format I need, not the actual data.

Currently I have the date in one column and the time in another.

The date is a string (varchar) not a datetime type.

I need to combine the date and the time into a single datetime data field in the the view.

Thanks
This is the statement in the view:

I need to combine the Scene Date and Scene Time into a single datetime column in the view.

SELECT     dbo.FDC_Trips.tdate, dbo.Companies.name AS Agency, dbo.FDC_Trips.veh AS Unit, dbo.FDC_Trips.RunNumber AS [Incident #],
                      dbo.FDC_Trips.outcomedescr AS Outcome, dbo.FDC_Trips.IncidentNumber1 AS [RMS #], dbo.FDC_Trips.g2pcrid AS [PCR ID],
                      dbo.v_FDC_MiscFields.UserField15Value AS [Service Level], dbo.FDC_Trips.completedTime AS [Comp. Time], dbo.Drivers.name AS [Completed By],
                      dbo.FDC_Trips.atsdate AS [Scene Date], dbo.FDC_Trips.atstime AS [Scene Time]

User generated image
What is your database?
SQL 2008R2
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank You. That worked...