Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> OCI Session date formating

OCI Session date formating

From: Vic <vic_at_who.com>
Date: Mon, 24 Jan 2000 01:42:01 -0800
Message-ID: <IwSi4.1$9S5.352@news.pcnet.com>


anyone know how to change the default in/out date format using OCI (c version) for a session.

I would have thought that the following would have worked but it does not.

(void) OCIAttrSet((dvoid *)authp, (ub4)OCI_HTYPE_SESSION, NEW_ORACLE_DATE_FORMAT,
     (ub4) strlen(NEW_ORACLE_DATE_FORMAT), (ub4)OCI_ATTR_DATEFORMAT, errhp));

authp being the session pointer
errhp being the the error pointer

NEW_ORACLE_DATE_FORMAT = "YYYY-MM-DD HH24:MI:SS" any ideas would be appreciated. Thanks in advanced. Received on Mon Jan 24 2000 - 03:42:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US