char another_dt[21];
EXEC SQL VAR another_dt IS STRING(21);
EXEC SQL BEGIN DECLARE SECTION;
varchar dt[21];
EXEC SQL END DECLARE SECTION;
strcpy(user,"XXXXX@xxx.xxx");
strcpy(passwd,"XXXXX");
EXEC SQL WHENEVER SQLERROR DO print_error_msg();
EXEC SQL WHENEVER SQLWARNING DO print_warning_msg();
EXEC SQL CONNECT :user IDENTIFIED BY :passwd;
memset(dt.arr,'',21);
EXEC SQL SELECT TO_CHAR(sysdate,'DD/MON/YYYY HH24:MI:SS') into :dt from dual;
EXEC SQL SELECT TO_CHAR(sysdate,'DD/MON/YYYY HH24:MI:SS') into :another_dt from dual;
dt.len = strlen(dt.arr);
printf("Date is :%sn",dt.arr);
printf("Another Date is :%sn",another_dt);
Sunday, February 8, 2009
Subscribe to:
Post Comments
(
Atom
)
0 comments :
Post a Comment