Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 question

Author  Topic 

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-08-05 : 16:26:38
I have below date values in a table:

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-08-05 : 16:35:24
You just want to add 30 minutes to an existing date? Look at DATEADD in Books Online.

Be One with the Optimizer
TG
Go to Top of Page

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-08-05 : 16:59:52
Man, I've got to start "reply with quote"ing

Be One with the Optimizer
TG
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-08-06 : 03:20:43
quote:
Originally posted by sqlserverdeveloper

I have below date values in a table:



There are no values

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-08-06 : 09:51:38
quote:
Originally posted by TG

Man, I've got to start "reply with quote"ing

Be One with the Optimizer
TG



Sorry it was my bad, accidently I edited the original request of mine. Actually your answer helped me to resolve the issue, thanks for your speedy response, I greatly appreciate it. My original request was:
How to incremet the time part of a date value every n minutes.
Go to Top of Page
   

- Advertisement -