Archives of the TeradataForum

Message Posted: Thu, 24 Oct 2002 @ 18:36:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Bob:

There are times when I find it too long or cumbersome to write the entire EXTRACT function. So, when I want the day portion of a date, I tend to use the following to return the day portion:

mydate mod 100

Likewise, month = (mydate /100) mod 100

Hope this helps,

Mike

	<Prev	Next>		<<First	<Prev	Next>	Last>>