Add or Subtract Hours in SQL or ASP using DateAdd

This would not work for me.
"getdate" does not seem to be a valid comand only "date" was valid.

dave - getdate() is for SQL server only. Silly me! I've added an example using the Access equivalent - date()
Thanks
jeff

What about when daylight savings is switched on and your target location is in a place without daylight savings?

Does anyone know the DB2 equivalente
for the DATEADD funtion?

This is the problem i need to solve:

I am currently using DateAdd()as in the following example:

DATEADD(s,[Create_date] + 3600,'01/01/1970') AS Create_date

You can see that I am adding 3600 secs. In summer months, I need to change this parameter to 7200 secs for clients in another time zone.

How can I do this automatically ?

Thanks,

Victor.

i want to add hour and minute together i.e: 9 hours and 28 minutes.

i want to add 9 hours and 28 minutes togethrt in email_date field
select dateadd(hour,9,email_date) as date1 from support_email
select dateadd(minute,28,date1) from support_email

i want to add 9 hours and 28 minutes together in email_date field
select dateadd(hour,9,email_date) as date1 from support_email
select dateadd(minute,28,date1) from support_email

Ahh.. but what about more practical applications like if you had a timesheet program using asp and an access database and you needed to get the total hours worked. so you have a start time and an end time that a user enters in the ASP interface but when you insert into the db you want to enter the times plus a total?

sorry to ask but I am lost lost lost.

Shane, if you have figured it out, please let me know. I'm in a similar situation.

If I find an answer, I'll come back and post it.

poor example

Had problems when using the above for ASP but found that you need to put quotes around time/date value.

E.G

DATEADD("d",2,Now()) = In two days time

DATEADD("d",-2,Now()) = Two days ago


Best Regards

Sharky99x

[quote]
i want to add 9 hours and 28 minutes together in email_date field
select dateadd(hour,9,email_date) as date1 from support_email
select dateadd(minute,28,date1) from support_email
[/quote]

just nest your functions:

[b]select dateadd(mi,28,dateadd(h,9,email_date)) as result_date from support_email[/b]

jeremy

Hi,
Can anyone help?
I want to set up a field in a table which adds 13 weeks to another field in a table (called aevents.date_received) automatically on each new record entry.
I would be grateful for any help.
Thanks,
Laura