On Tue, Jan 25, 2005 at 10:11:40 -0500, Joel Fradkin <[EMAIL PROTECTED]> wrote: > Hi all working my way through our views and all is going very well. > > We use datediff in MSSQL a bit and I read about the field1::date - > field2::date to return the days numerically. > > Is there any way to get months and years besides guessing days / 30 for > months etc?
The age function will give a difference in years-months in addition to days-hours-minutes-seconds. Depending on what you want, it may not do exactly what you want. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])