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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
converting timestamp to day(4) to minute
- Thread starter bablu123
- Start date
The ANSI SQL way is:
[tt]
select * from table
where condition
AND ( ( time1 - time2 ) DAY ( 4 ) TO MINUTE ) >= INTERVAL '0 00:01' DAY(4) TO MINUTE[/tt]
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.
[tt]
select * from table
where condition
AND ( ( time1 - time2 ) DAY ( 4 ) TO MINUTE ) >= INTERVAL '0 00:01' DAY(4) TO MINUTE[/tt]
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.
- Thread starter
- #4
I think you want this
-----------------------------------------
I cannot be bought. Find leasing information at
Code:
select * from table where ((time1 - time2) DAY TO SECOND) >= interval '+00 00:01:00' day to second-----------------------------------------
I cannot be bought. Find leasing information at
- Thread starter
- #6
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
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
I'm using oracle. Isn't that what you're trying to convert to? My understanding is that by specifying interval I am making an explicit conversion instead of an implicit one. But it will probably work without specifying interval since you can use the default day and seconds precision on the right side.
-----------------------------------------
I cannot be bought. Find leasing information at
-----------------------------------------
I cannot be bought. Find leasing information at
- Status
Similar threads
