oracle nls params date timestamp format
ghdrako edited this page Dec 29, 2023
·
1 revision
NLS_TIMESTAMP_FORMAT defines the default timestamp format to use with the TO_CHAR and TO_TIMESTAMP functions. Uwaga W formacie timestampa ma byc dokładnie dwa F czyli '.FF' - nie więcej !!!!
NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH:MI:SS.FF'
NSL_DATE_FORMAT = 'YYYY-MM-DD HH:MI:SS'
SELECT TO_TIMESTAMP('11-nov-2000 01:00:00.336', 'dd-mon-yyyy hh:mi:ss.ff') FROM DUAL;
Test