Project

General

Profile

timestamp without time zone... should I care

Added by Mark Petryk about 9 years ago

When I allow Wt to create my tables, I noticed that my date/time columns are indicating 'without time zone'... Is this important? Does it matter? Is there a way to specify a time/date column in the table that 'has' a time zone?

                                              Table "public.ccbPrjCB"
          Column           |            Type             |                        Modifiers                        
---------------------------+-----------------------------+---------------------------------------------------------
 id                        | bigint                      | not null default nextval('"ccbPrjCB_id_seq"'::regclass)
 version                   | integer                     | not null
 isActive                  | boolean                     | not null
 isVisible                 | boolean                     | not null
 isDeleted                 | boolean                     | not null
 keyField                  | character varying(250)      | not null
 cfyField                  | character varying(80)       | not null
 varField                  | text                        | not null
 uidField                  | character varying(40)       | not null
 pMode                     | integer                     | not null
 createdOn                 | timestamp without time zone | 
 changedOn                 | timestamp without time zone | 
 p_sysUser_id              | bigint                      | 
 p_sysGroup_id             | bigint                      | 
 accountKey                | text                        | not null
 amountPaid                | double precision            | not null
 clientEmail               | text                        | not null
 clientPhone               | text                        | not null
 creditTotal               | double precision            | not null
 invoiceKey                | text                        | not null
 lastActivity              | timestamp without time zone | 
 managerSignOff            | text                        | not null
 notes                     | text                        | not null
 openedOn                  | timestamp without time zone | 
 paymentNotes              | text                        | not null