Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Different time zones
Is there a way to have a sql query display a date column using the client's
local time zone instead of the time zone on the server? For example say I
insert a row into a database in New York (EST) with the time of 14:00. If
someone on CST selects the row I want it to show 13:00. If somone else on
EST selects it I want it to say 14:00. Can this be accomplished without
using the new_time() function?
Received on Mon Jul 29 2002 - 14:11:07 CDT