#DateForumTypeThreadPost
528 Aug 2013 @ 06:33 PDTAnalyticsReplyteradataR package and R 3.0.0Yes Teradata, please support R by updating the package or releasing the source code.
412 Mar 2013 @ 08:00 PDTAnalyticsReplyDifference between TimestampFrom another thread and some playing around, I found that this works:   SELECT CURRENT_TIMESTAMP AS t2, (t2 - INTERVAL '9999' DAY - INTERVAL '30' DAY + INTERVAL '1...
311 Mar 2013 @ 07:00 PDTAnalyticsReplyDifference between Timestamp  What can you do if there are more than 9999 days between the timestamps?  I am trying to get the number of seconds elapsed (ideally as decimal rather than interval).  For insta...
223 Jan 2013 @ 07:02 PSTDatabaseReplyNumber of seconds elapsed since beginning of dayThanks Dieter.  I was thinking there would be a way to do it in one `cast` instead of three `extract`s, but it probably doesn't matter and this works fine.
122 Jan 2013 @ 09:59 PSTDatabaseTopicNumber of seconds elapsed since beginning of dayI have a timestamp with time zone field and I would like to get the number of seconds that have elapsed from the start of that day.  This seems like it should be very trivial but I've sear...