Re: [SQL] TIME ZONE SQL

Hi Richard, What I am having is CREATE TABLE "customer_events" ( "event_id" numeric (10) NOT NULL, "customer_id" numeric (10) NOT NULL, "event_name" varchar (100) , "event_datetime" date , "start_time" time , "repeat_untill_date" date , "send_before_time" time, "time_difference" time PRIMARY KEY

Re: [SQL] Query TIME ZONE

Thanks Tom it worked for me... yes I got it wrong.. thanks for the correction. thanks a lot.. -- Raman - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Raman" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 28, 2004 11:28 AM Subject: Re: [SQL] Query TI