sysdate - 15

siva_nagarajan · #1 (**permalink**) 07-14-11, 11:23

hi all,

I would like to know the query to calculate date 15 days before the sysdate.
i.e. (sysdate-15)

Thanks for your help in advance.

pradyut.dhara · #2 (**permalink**) 07-14-11, 13:37

Hi,
1> select dateadd(dd,-15,getdate())
2> go

--------------------------
Jun 29 2011 11:07PM

(1 row affected)
1>

siva_nagarajan · #3 (**permalink**) 07-15-11, 00:31

Hey pradyut,

Thanks for your help. 2 more things I require..
1. The way to store the output in the variable
2. A good source to learn sybase.

Thanks again.

pradyut.dhara · #4 (**permalink**) 07-15-11, 02:53

Hi,
here you go.
1> declare @d1 char(8)
2>
3> select @d1= convert(char(8),dateadd(dd,-15,getdate()),112)
4> print "%1!",@d1
5> go
(1 row affected)
201106301>

Internet Services

Web Development

Digital Marketing

Consumer Tech