|
Archives of the TeradataForumMessage Posted: Mon, 06 Jul 2009 @ 13:07:59 GMT
Hi. 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: Works: SEL CAST(((DATE - DATE '2009-07-01') DAY) AS FLOAT)*24*60*60 Doesn't work: 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? Best regards LS
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||