Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql timestamp problem

Re: sql timestamp problem

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 27 Jun 2006 21:29:32 +0200
Message-ID: <e7s0ou$9ij$1@news6.zwoll1.ov.home.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US