converting timestamp to day(4) to minute
converting timestamp to day(4) to minute
(OP)
Hi guys,
Iam converting teradata sql to Pl/sql
In teradata i have
select * from table
where condition
AND ( ( time1 - time2 ) DAY ( 4 ) TO MINUTE ) >= '0 00:01.
so the above query has to work in oracle
can any one help me out
thanks in advance
Iam converting teradata sql to Pl/sql
In teradata i have
select * from table
where condition
AND ( ( time1 - time2 ) DAY ( 4 ) TO MINUTE ) >= '0 00:01.
so the above query has to work in oracle
can any one help me out
thanks in advance
RE: converting timestamp to day(4) to minute
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
RE: converting timestamp to day(4) to minute
select * from table
where condition
AND ( ( time1 - time2 ) DAY ( 4 ) TO MINUTE ) >= INTERVAL '0 00:01' DAY(4) TO MINUTE
But, as r937 already said, you'd better ask this question in an Oracle forum. Date/time handling is one of the worst areas when it comes to ANSI compliance. Too many vendors have their own, non-standard, implementations.
RE: converting timestamp to day(4) to minute
But iam gone with day(4)to second like this
AND ( ( time1 - time2 ) DAY ( 4 ) TO SECOND ) >= '0 00:01:60.
iam not sure this is the way doing.
RE: converting timestamp to day(4) to minute
CODE
-----------------------------------------
I cannot be bought. Find leasing information at http://www.joshaxtell.com/
RE: converting timestamp to day(4) to minute
actually in teradata we donot use INTERVAL
we just
( ( time1 - time2 ) DAY ( 4 ) TO MINUTE ) >= '0 00:01.
i think it will work.
can you explain me why you are using interval..
( ( time1 - time2 ) DAY ( 4 ) TO SECOND ) >= '0 00:00:60.'
you can check teradata query here
http://www.teradataforum.com/l081007a.htm
RE: converting timestamp to day(4) to minute
-----------------------------------------
I cannot be bought. Find leasing information at http://www.joshaxtell.com/