| View previous topic :: View next topic |
| Author |
Message |
samir
Joined: 12 Nov 2007
Posts: 260
|
 Posted: Mon Jun 01, 2009 9:38 am Post subject: increment timestamp by 1 week |
 |
|
Hi,
I want an sql query where i can increment the original timestamp by 1 week , please can any one suggest me..........
Thanks |
|
| Back to top |
|
 |
samir
Joined: 12 Nov 2007
Posts: 260
|
| Posted: Mon Jun 01, 2009 9:41 am Post subject: |
|
|
hi,
The following query meets your requirement ,
SELECT DISTINCT {fn TIMESTAMPADD(SQL_TSI_WEEK,1,'2003-12-20 12:00:00')}FROM Sample.Person |
|
| Back to top |
|
|
|
