Extract number of days from interval.

[splendided]

Quick question anyone ..

How do I extract the number of days from an interval which spans several years.

Thanks

Ed

 

[feherke]

Hi

[b]select[/b] date_part([i]'day'[/i],now()-[i]'2000-01-01'[/i]) [b]as[/b] "Days elapsed from this millennium";

Feherke.

http://rootshell.be/~feherke/