SQL Help with dates

SQL Help with dates

 

  

Hi,
Can anyone give me the string to compare 2 dates returning only the
records that the first date is over 30 days later than the second.
Thanks
Kevin

Kevin J Kenny
Manager of Support Services
Clinical Practice Management Plan
Stony Brook, NY 11790-0988
631-444-0595
Kevin.[Email Address Removed] This e-mail and the attachments hereto, if any, may contain
privileged and/or confidential information. It is intended only for use
by the named addressee(s). If you are not the intended recipient of this
e-mail, you are hereby notified that any dissemination, distribution or
copying of this e-mail and the attachments hereto, if any, is strictly
prohibited. If you have received this transmission in error, please
immediately notify the sender by telephone and permanently delete this
e-mail and the attachments hereto, if any, and destroy any printout
thereof.
Oracle LazyDBA home page