Re: Saving Current time in a date field from SYSDATE
From: zhix <zmilos_at_sympatico.ca>
Date: 15 Dec 2001 12:59:37 -0800
Message-ID: <c59f4459.0112151259.72aa5e53_at_posting.google.com>
Date: 15 Dec 2001 12:59:37 -0800
Message-ID: <c59f4459.0112151259.72aa5e53_at_posting.google.com>
try
ALTER SESSION SET NLS_DATE_FORMAT='fmHH24:MM:SS';
check values in
select * from v$nls_parameters;
Received on Sat Dec 15 2001 - 21:59:37 CET