1
vote
1answer
21 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
17 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
22 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 …