Archives of the TeradataForum
Message Posted: Mon, 06 Jul 2009 @ 13:07:59 GMT
I have some problem with date calculation.
I'm trying to get number of seconds between two dates, but it only works for a small scale like few days earlier:
SEL CAST(((DATE - DATE '2009-07-01') DAY) AS FLOAT)*24*60*60
SEL CAST(((DATE - DATE '2008-07-01') DAY) AS FLOAT)*24*60*60
I'm out of ideas..
Could you tell me please, what I'm doing wrong?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|