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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...
  2. bablu123

    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.
  3. bablu123

    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

Part and Inventory Search

Back
Top