I have two Columns in my SQL Table. One is DateTime and The other is Time
They are in the Format,
DateTime - 2012-04-05 16:58:56.000 and Time - 21:30:00.00000
I need to write a Query which will return a Column as - 2012-04-05 21:30:00.000
Can you Help me?
In SQL-Server 2008, you can add the values this way:
select cast(dt as date) + cast(tm as datetime)
from yourtable
The above no longer works, here is an updated version that will work in SQL Server. This can also be edited to include additional precision:
SELECT dateadd(day, datediff(day,'19000101',dt), CAST(tm AS DATETIME))
from yourtable
This Worked For Me.
Select DateAdd(d, DateDiff(d, 0, Cast(OrderDate As datetime)), Cast(Delivery_Time as datetime)) From myTable
SELECT CAST(date_col AS DATETIME)+CAST(time_col AS DATETIME) FROM your_table
Tested on SQL SERVER 2012
Try this::
Select CONCAT(DATE(column_dateTIME),column_Time) from my Table
'DATE' is not a recognized built-in function name.
For MySQL
Select CONCAT_WS(" ", date(dattime_columnname), time(time_column)) from table_name;
For SQL Server 2008:
select convert(varchar, datetime_column, 103) + ' ' + convert(varchar, time_column, 114)
try this:
This should work in SQL SERVER
select CONVERT(varchar(10),dt_col,121)+' '+cast(t_col as varchar(20))
from your_table
