New DateFormat for Oracle for Date and Time

[Nick Matteucci]

Here is my code. No matter how many times / ways I enter the time after the date - it is dropped during update. It looks like it saves it but it does not. Run it against Oracle and see for yourself...

I tried DateFormat=DD-MMM-YYYY HH:MM:SS and no luck

How do we enter dates and times with this new format feature?

Nick

<%
Set X = Server.CreateObject(&#34;aspDB.EP&#34
X.dbDSN=&#34;DSN=local; UID=scott; PWD=tiger&#34;
X.dbDbType=&#34;Oracle&#34;
X.dbUnit = 1
X.DbMode = &#34;Grid&#34;
X.dbSQL = &#34;($~)SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, &#34; &_
&#34;EMP.HIREDATE, &#34; &_
&#34;EMP.SAL, EMP.COMM, EMP.DEPTNO FROM EMP ORDER BY EMP.EMPNO&#34;
X.dbOptions=&#34;DateFormat=DD-MMM-YYYY&#34;
X.dbMagicCell=&#34;4,,Format=[mm/dd/yyyy hh:mm:ss];&#34;
X.dbNavigationItem=&#34;top, bottom, next, prev, update&#34;
X.dbEditParams=&#34;TableName=SCOTT.EMP,BookMarkFl ds=0,TableTag=BORDER=2,&#34;
X.dbEditFlds=&#34;1,2,3,4,5,6,7&#34;
X.aspDBEP
%>

[Nick Matteucci]

No Frank - not the date - the DATE AND TIME TOGETHER.

Please try to show me any example with Oracle where you execpt the date and time. I feel I have tried everything.

Try to enter one of the following:

2/2/99 12:12:12
02/02/1999 12:12:12

See how it strips off all the dates in the database?

Please help...

Nick

------------
Frank at 12/7/99 11:43:11 PM

I changed to my setting and cleaned up the code a bit and using it in my EP version and it worked fine. What is the version you are running ?

I changed the HIRED DATE of SMITH CLERK from 10/12/79 to 10/12/80 (no need for ORACLE DATE format !!) and it worked fine. If still have problem then I&#39;ll post this one also in my support server. First, check your EP version, it must be >= 2.22.03.

<%
Set X = Server.CreateObject(&#34;aspDB.EP&#34
X.dbDSN=&#34;DSN=Ora805; UID=scott; PWD=tiger&#34;
X.dbDbType=&#34;Oracle&#34;
X.dbUnit = 1
X.DbMode = &#34;Grid&#34;
X.dbSQL = &#34;($~)SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, &#34; &_
&#34;EMP.HIREDATE, &#34; &_
&#34;EMP.SAL, EMP.COMM, EMP.DEPTNO FROM EMP ORDER BY EMP.EMPNO&#34;
X.dbNavigationItem=&#34;top, bottom, next, prev, update&#34;
X.dbEditParams=&#34;TableName=SCOTT.EMP,BookMarkFl ds=0,TableTag=BORDER=2,&#34;
X.dbEditFlds=&#34;1,2,3,4,5,6,7&#34;
X.aspDBEP
%>

FK


------------
Nick Matteucci at 12/7/99 10:38:55 PM

Here is my code. No matter how many times / ways I enter the time after the date - it is dropped during update. It looks like it saves it but it does not. Run it against Oracle and see for yourself...

I tried DateFormat=DD-MMM-YYYY HH:MM:SS and no luck

How do we enter dates and times with this new format feature?

Nick

<%
Set X = Server.CreateObject(&#34;aspDB.EP&#34
X.dbDSN=&#34;DSN=local; UID=scott; PWD=tiger&#34;
X.dbDbType=&#34;Oracle&#34;
X.dbUnit = 1
X.DbMode = &#34;Grid&#34;
X.dbSQL = &#34;($~)SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, &#34; &_
&#34;EMP.HIREDATE, &#34; &_
&#34;EMP.SAL, EMP.COMM, EMP.DEPTNO FROM EMP ORDER BY EMP.EMPNO&#34;
X.dbOptions=&#34;DateFormat=DD-MMM-YYYY&#34;
X.dbMagicCell=&#34;4,,Format=[mm/dd/yyyy hh:mm:ss];&#34;
X.dbNavigationItem=&#34;top, bottom, next, prev, update&#34;
X.dbEditParams=&#34;TableName=SCOTT.EMP,BookMarkFl ds=0,TableTag=BORDER=2,&#34;
X.dbEditFlds=&#34;1,2,3,4,5,6,7&#34;
X.aspDBEP
%>