Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by bablu123
-
converting timestamp to day(4) to minute
Hi Jaxtell 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... -
converting timestamp to day(4) to minute
Actually when i try to use day(4)to minute in Oracle Pl/Sql it won't work 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. -
converting timestamp to day(4) to minute
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
