| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql timestamp problem
Mohan schreef:
> Hi
>
> I am using Oracle 10.1.0.4. When I am storing events with the received
> timestamps, it stores in GMT. But I am calling the stored procedure
> with timestamp in IST. Similarly when I search for that using IST, It
> returns the results matching the corresponding GMT. If I search 6.30 AM
> IST, It returns results for 1.00 AM.
>
> Appreciate your help
>
What is the problem? Looks like you have a timestamp with timezone, but crystal balls break easily these days, an I am somewhat clumsy...
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Tue Jun 27 2006 - 14:29:32 CDT
![]() |
![]() |