oracle nls params date timestamp format - ghdrako/doc_snipets GitHub Wiki

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;