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