MS SQL Server, adding the date part of datetime to the time part of datetime

adding the date part of datetime to the time part of datetime

Author	Message
PAN #1 / 5	adding the date part of datetime to the time part of datetime How can I do this? For example: Datetime1 = 09/01/2000 00:00:00 Datetime2 = 01/01/1900 15:25:00 and what I want to get out is: Result = 09/01/2000 15:25:00 Thanks for any helps, PAN
Tue, 25 Feb 2003 05:00:03 GMT

Tibor Karasz #2 / 5	adding the date part of datetime to the time part of datetime PAN, Sure can. There might be other methods, but I'd do it through converting to characters: -- Tibor Karaszi, SQL Server MVP Please reply to the newsgroup only, not by email. See Neil Pike's FAQ at: http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 Quote: > How can I do this? > For example: > Datetime1 = 09/01/2000 00:00:00 > Datetime2 = 01/01/1900 15:25:00 > and what I want to get out is: Result = 09/01/2000 15:25:00 > Thanks for any helps, > PAN
Tue, 25 Feb 2003 15:45:49 GMT

Gusta #3 / 5	adding the date part of datetime to the time part of datetime PAN, this is my solution: Gustav
Tue, 25 Feb 2003 16:50:15 GMT

PAN #4 / 5	adding the date part of datetime to the time part of datetime Thanks guys for your helps! PAN Quote: > How can I do this? > For example: > Datetime1 = 09/01/2000 00:00:00 > Datetime2 = 01/01/1900 15:25:00 > and what I want to get out is: Result = 09/01/2000 15:25:00 > Thanks for any helps, > PAN
Tue, 25 Feb 2003 22:35:20 GMT

Ivan Arjentinsk #5 / 5	adding the date part of datetime to the time part of datetime PAN, Try this: -- Ivan Arjentinski ----------------------------------------------- Please answer only to the newsgroups. I'll not answer any direct emails. ----------------------------------------------- Quote: > How can I do this? > For example: > Datetime1 = 09/01/2000 00:00:00 > Datetime2 = 01/01/1900 15:25:00 > and what I want to get out is: Result = 09/01/2000 15:25:00 > Thanks for any helps, > PAN
Wed, 26 Feb 2003 01:46:06 GMT

Page 1 of 1

[ 5 post ]