days between 2 dates

[Anon]

Hello,

I wanted to know number of days elapsed between 2 days. I want a function similar to dateserial available in other languages like vb.
Please help

Thanks,
Saurabh

[Anon]

select PERIOD_DIFF(Date1,Date2) from table ...

It'll give the number of months !
hope this will help you