sql*plus or pl/sql question

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bradley Connor Grasshopper Points: 10 More actions · Answer 1

Apparently i should use DATEDIFF ... how do i use DATEDIFF?

SQLBill SSC Guru Points: 51440 More actions · Answer 2

DATEDIFF(datepart, startdate, enddate)

Example: SELECT DATEDIFF(d, '2005-10-01', GETDATE())

Refer to the BOL for more information.

-SQLBill

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

Bradley,

If, as your subject suggests, you're trying to do this in Oracle, you don't have to use a function at all. Just subtract the dates. See this link:

Greg