Tagged Questions

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 …