ASE Database forum - Is there a relativedate() function in sql?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Is there a relativedate() function in sql?

VMI

2005-04-13, 8:24 pm

Is there a relativedate() function in sql that gives a
specific number for a certain date?

Thanks.

Mark Maslow

2005-04-13, 8:24 pm

function is dateadd

Example given in doc:

select newpubdate = dateadd(day, 21, pubdate)
from titles

Displays the new publication dates when the publication dates of all the
books in the titles table slip by 21 days.

The function can add any date part - from milliseconds to years - not
just days.

In article <425da463.4eed.1681692777@sybase.com>, VMI says...
> Is there a relativedate() function in sql that gives a
> specific number for a certain date?
>
> Thanks.
>

Sponsored Links