0
votes
1answer
120 views
Speeding up SELECT MAX(timestamp_column) FROM T, when T is loaded via continuous TPump
How can I speed up a query that's currently doing a full table scan to get the maximum value of a timestamp column?
I have a large table with a timestamp column. There is a TPump …
0
votes
0answers
14 views
Need answers to the anomaly in calculating the timestamp difference
I have a query which calculates the timestamp difference as Duration in hours & minutes and Then Rounds it to the closest hour based on the rule:
For ex: If minutes > 29, then …
1
vote
1answer
242 views
Timestamp difference
Hi Experts,
Need help here. In Oracle when we do timestamp difference. The resultset would be days and with some decimal numbers. For Eg.
SELECT '03.12.2004:10:34:24' "Now",
…
0
votes
1answer
212 views
convert seconds to timestamp
I have a table with a column that has the number of seconds since january 1 1970 in an integer column. How do I convert this to a timestamp in Teradata? When I try this
SELECT (UT …
0
votes
1answer
310 views
Timestamp diff with HOUR(4) TO SECOND(0)
Hi,
I am having problem in converting timestamp difference in Hour to Second
Earlier with timestam columns I get,
select (CLOSED_DATE-CREATED_DATE) hour(4) to second(0) from Ta …
