 |
 |
Archives of the TeradataForum
Message Posted: Wed, 14 Sep 2011 @ 09:51:22 GMT
| Subj: | | Re: Mdiff on Date field |
| |
| From: | | Dieter NC6th |
Anomy.Anom wrote:
| | I am trying to use mdiff on date field. It is working however when the month/year changes, the mdiff values are wrongly interpreted. I
guess this is due to the fact that TD stores date as integerdate. | |
And MDIFF seems to work on numeric data only, so there's an automatic typecast to INT. But you shouldn't use MDIFF anymore, as it's non-
Standard SQL.
Better rewrite it to:
dt - min(dt)
over (partition by id
order by dt
rows between 1 preceding and 1 preceding)
Dieter
| |
