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
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
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
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
ASKER
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.IncidentNumb er1 AS [RMS #], dbo.FDC_Trips.g2pcrid AS [PCR ID],
dbo.v_FDC_MiscFields.UserF ield15Valu e AS [Service Level], dbo.FDC_Trips.completedTim e AS [Comp. Time], dbo.Drivers.name AS [Completed By],
dbo.FDC_Trips.atsdate AS [Scene Date], dbo.FDC_Trips.atstime AS [Scene Time]
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
dbo.v_FDC_MiscFields.UserF
dbo.FDC_Trips.atsdate AS [Scene Date], dbo.FDC_Trips.atstime AS [Scene Time]
What is your database?
ASKER
SQL 2008R2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You. That worked...
and 10:20:00 to 13:12:00?