How to subtract Time Column from DateTime Column in SQL?

Question

0.00/5 (No votes)

See more:

Hi,
I have Crea_Date column which is a DateTime Column. I want to subtract the value in the IST column from crea_date Column and return a new column with the DateTime Value in it. My sample data is like this:

SQL

States  crea_date       IST
AB  2014-12-30 15:01:00.000 12:30:00.0000000
AK  2014-12-29 16:32:00.000 10:30:00.0000000
AZ  2014-12-18 16:07:00.000 11:30:00.0000000

Thanks in Advance

Posted 22-Jan-15 3:14am

ZohaibRazaTheDProgrammer

Updated 22-Jan-15 18:33pm

King Fisher

v2

Add a Solution

Comments

Zoltán Zörgő 22-Jan-15 14:57pm

Any progress?

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2015-01-22T03:38:00

Solution 1

As I know there is no other built-in method but to used DATEPART to extract hour, minute and second from the time field and use DATEDADD to substract these values from the original field value. It won't be a nice formula, but will work.

Posted 22-Jan-15 3:38am

Zoltán Zörgő

Updated 22-Jan-15 3:55am

v2

Comments

Richard Deeming 22-Jan-15 9:43am

Shouldn't that be "... use DATEADD to subtract ..."?
DATEDIFF is for getting the difference between two dates. :)

Zoltán Zörgő 22-Jan-15 9:55am

Right! Thank you. Corrected.

Liju Sankar · Answer 2 · 2015-01-22T18:58:00

Solution 2

Please check whether this works
http://stackoverflow.com/questions/13759278/how-can-i-subtract-6-hour-from-the-current-time[^]

http://stackoverflow.com/questions/3993226/c-whats-the-easiest-way-to-subtract-time[^]

Both these links recommending to use DateTime.Add(TimeSpan) method as a solution.

Posted 22-Jan-15 18:58pm

Liju Sankar

Updated 22-Jan-15 18:59pm

v2

How to subtract Time Column from DateTime Column in SQL?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to subtract Time Column from DateTime Column in SQL?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us