[aazurmendi]

Is there a setting that would allow me to see a date file as yyyy/mm/dd hh24:mi:ss I currently only yyyy/mm/dd ?
thanks

[aazurmendi]

Oops, for Oracle db create table “XXAR”.”XXAR_CCI_PARTY_MSSQL_AUDIT”(
“ID” NUMBER not null,
“PARTY_ID” NUMBER not null,
“PARTY_NAME” VARCHAR2(360) not null,
“SNOOZE_ENABLE” VARCHAR2(150) not null,
“SNOOZE_AMOUNT” VARCHAR2(150),
“DIRTY_FLAG” VARCHAR2(1),
“CREATION_DATE” DATE,
“LAST_UPDATE_DATE” DATE,
constraint “XXAR_CCI_PARTY_MSSQL_AUDIT_PK” primary key (“ID”)
);

[Haris Peco]

aazurmendi ,

MyEclipse show date in standard java format (it depend from your locale) and you can’t change default.However, you can use
Oracle’s function to_char in SQL Editor’s query and show format what you want. Example :

select to_char(CREATION_DATE,’yyyy/mm/dd hh24:mi:ss’)
from “XXAR”.”XXAR_CCI_PARTY_MSSQL_AUDIT”

Best
Peco

[Author]

Posts